Could not use '~'; file already in use

[KLK000]

I've read the threads about the permissions needed to address the .ldb file and I've set the permissions accordingly. However, my situation is a little different (I think). I've got an MS Access front end that uses linked tables to another MS Access DB. Whenever a second user tries to open the front end, he get's a message that says &quot;Could not use '<path to linked db>'; file already in use.&quot; Any ideas on how I can allow more than one person to open the front end at the same time?

 

[danvlas]

You may set the locking strategy of your forms to Edited Record instead of All Records and for the reports - No Locks instead of All Records...

And make sure users do NOT open the db in exclusive mode.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html