"File in use"

G

Guest

Hi,

I have several reference files in a database on my server. Several users
have simple front ends on their PCs linked to the database. The tables are
read-only, for reference purposes, nobody is doing any updating. It doesn't
get any simpler or more straight-forward. The problem is that sometimes one
of my users gets a "file in use" message when she tries to open the file.
Even stranger, if she opens the file first, the others can get in without
problem but if someone else opens before her, she is locked out. Everyone has
the same front end. There's no security of any kind.
Anyone ever hear of something like this? Any ideas?

TIA,
Lynne
 
A

Al Camp

Lynne,
You didn't mention what version of Access you're using, but... on that
rouge PC...

Check out Tools/Options/Advanced. (options differ slightly from version
to version)

Try Default Open Mode = Shared, Record Locking = None.
If 2003 then also uncheck Open Database with Record Level locking.

Does that make a difference?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top