Shared database problem

  • Thread starter Thread starter Steve M
  • Start date Start date
S

Steve M

Hi I keep getting the follwing error
'You do not have exclusive acess to the database at this time. Your design
changes will not be saved.'
I want multi user access to the forms. When this happens no one is in
design mode. The settings are set to shared - no locks.

I just cant understand it,

any ideas??

baz
 
is your database split? that is, backend (tables only) on the server, and a
copy of the frontend (all objects except tables) on each user's PC. if not,
recommend you split it - multiple users in a monolithic database is just
begging for database corruption.

hth
 
For multi user access to a single mdb file, MSAccess creates a seperate
file with the extension "ldb". If you don't have sufficient file system
privileges to create or access that ldb-file, it might be a problem.

You might also want to check if there is an old ldb-file which cannot be
deleted or updated by MSAccess. Try to delete it manually, but make
sure that everybody closes the database first.
 
In Access 2000 and later, you must have exclusive Access to the MDB to save
design changes. No other user must have that MDB open - it doesn't matter
that the other users are not making design changes.

The solution, as Tina suggests elsewhere in this thread, is to split the
'front end' application MDB from the 'back end' data MDB, so that you can
make design changes to a local copy of the application MDB and copy it to
the users' PCs without overwriting data.
 
Roland said:
For multi user access to a single mdb file, MSAccess creates a seperate
file with the extension "ldb". If you don't have sufficient file system
privileges to create or access that ldb-file, it might be a problem.

You might also want to check if there is an old ldb-file which cannot be
deleted or updated by MSAccess. Try to delete it manually, but make
sure that everybody closes the database first.
Click to expand...
 
these symptoms are not as obvious if you use Access Data Projects.

I mean-- you can do any table operations you want with MSDE/SQL Server
and you wouldn't have to run around and kick people out of the file any
time you needed to do something
 
Back
Top