access in share mode, but not sharing

[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

 

[Douglas J. Steele]

What permissions do your users have on the folder where the MDB file is
located?

They need Read, Write, eXecute and Delete access.

 

[Jack Black]

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

 

[Gary]

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