access 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
 
What permissions do your users have on the folder where the MDB file is
located?

They need Read, Write, eXecute and Delete access.
 
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
 
My suggestion is that one of your end users may be opening the database
exclusively and thus it doesn't matter what the shared mode is.

Your best bet may be to make an MDE file (Tools - Database Utilities - Make
MDE file) and copy the MDE file to each user locally. If you have as few
users as you seem to have, it shouldn't be a problem. That way they can't
mess with your code or designs (purposefully or by accident).

hth,
Gary
 
Back
Top