Cannot use xxx.mdb; file already in use - why?

[MontyBurns]

Hi,

I just worked on a DB that I look after yesterday. All I did was to attach the tables by using code (some linked, some imported) using UNC path's rather than a locally mapped drive letter (i.e previously done thru the Link Tables dialogs).

Now i've found that only one person can use the DB at a time. Permissions haven't changed and the file is working in Shared mode, not Exclusive.

Any ideas?

Thanks,
Burns

 

[jfischer]

Check the sharing/locks on the target tables of the links. It may be the UNC tables that are locked, not the XXX.MDB.