Access 2000 in share mode, but not sharing

  • Thread starter Thread starter Jack Black
  • Start date Start date
J

Jack Black

HI All

I have my access 2000 database in "share" mode so many users can use it at
once.

However, even though it's set for sharing, it still won't allow more than
one user at a time.

Any ideas?

Thank you, Jack
 
Jack said:
HI All

I have my access 2000 database in
Click to expand...
"share" mode so many users can use
it at once.

However, even though it's set for
Click to expand...
sharing, it still won't allow more
than one user at a time.
Click to expand...

Starting with 2000, you must have
exclusive access to make design changes.
One usually splits the database, so that
you can make design changes in your copy
of the frontend.

If it isn't related to making design
changes, check the windows folder
permissions. Users need full
permissions on the folder in order to
create/delete the associated ldb file.
 
Hi Joan

Thanks for the reply.

Everyone has full permissions to the folder. It's just that Access 2000,
even though in the "share" mode, still comes back with the error, "Cannot
use.. database.mdb, file already in use" error message.

Any ideas?

Thanks, Jack
 
sounds like the ldb file is not being recreated each
time. this is probably an issue with folder permissions.
users must have create and delete permission
 
Jack said:
Hi Joan

Thanks for the reply.

Everyone has full permissions to the folder. It's just that Access
2000, even though in the "share" mode, still comes back with the
error, "Cannot use.. database.mdb,
Click to expand...
file already in use" error message.

Get everyone out of the mdb and see if
there is a ldb file that remains. If
so, delete it. Are you positive that
*every* user has full permissions?
 
Back
Top