P
Pramod Vispute
I am working on maintenance Access project. This database
in one shared folder of network. Those want to use, create
shortcut of that and use it.
Every body has full control of that folder.
A database contains every object like forms, rpts,
queries, macro, tables.
I am using on W2K Operating system and Access XP (Access
2002).
And hope default open mode is shared and record
locking "No Locks", as I am not getting Tools/option menu.
If 4 users working on it and fifth user joining it
following message pops up.
I observed the .ldb file also. It was showing 7 users
logged on with machine name and followed by "Admin" Word.
Here is a description of the error window that pops up
when the database becomes "locked":
================================================
The database '\\SharedMe\MultiMedia\MyMedia DB.mdb' needs
to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft
Access while a Microsoft Access database was open. Do you
want Microsoft Access to attempt to repair the database?
Yes No
================================================
After this message appears, all users must quit out of the
database and then one user must repair it before other
users can log on again.
As message says abnormal exiting of any user, you can't
recognize which use exit obnormally?
Any help would be appreciated
in one shared folder of network. Those want to use, create
shortcut of that and use it.
Every body has full control of that folder.
A database contains every object like forms, rpts,
queries, macro, tables.
I am using on W2K Operating system and Access XP (Access
2002).
And hope default open mode is shared and record
locking "No Locks", as I am not getting Tools/option menu.
If 4 users working on it and fifth user joining it
following message pops up.
I observed the .ldb file also. It was showing 7 users
logged on with machine name and followed by "Admin" Word.
Here is a description of the error window that pops up
when the database becomes "locked":
================================================
The database '\\SharedMe\MultiMedia\MyMedia DB.mdb' needs
to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft
Access while a Microsoft Access database was open. Do you
want Microsoft Access to attempt to repair the database?
Yes No
================================================
After this message appears, all users must quit out of the
database and then one user must repair it before other
users can log on again.
As message says abnormal exiting of any user, you can't
recognize which use exit obnormally?
Any help would be appreciated