Only one person can be in database at a time.

[WBM]

Database was working fine. It's split into Front and Back Ends. Printed
some PDFs of some reports which introduced me to the Adobe/Access conflict
(which we've since disabled). Database was working fine again for a day or
so. Now, same problem as before (only one person can get into database at a
time). The Adobe/Access link is still disabled.

Any suggestions?

 

[Jerry Whittle]

Get everyone out of the database and see if there is still a .ldb file in the
folder(s) holding the mdb files. If so delete it.

All users of the database must have at least read, write, and modify
privileges to the folders holding the database files. Not just the database
..mdb file, but the entire folder.

Open the database and go to Tools, Options, and Advanced Tab. Set the
Default Open mode to Shared and the Default Record Locking to Edited Record.
(While you are in the Options area, go over to the General tab and turn off
Compact on Close and Name AutoCorrect. Trust me on this.)

Make sure that the code in the FE is compiled then do a Compact and Repair
of both the FE and BE files.

 

[WBM]

I'll give that a try and let you know.

Thanks.

Get everyone out of the database and see if there is still a .ldb file in the
folder(s) holding the mdb files. If so delete it.

All users of the database must have at least read, write, and modify
privileges to the folders holding the database files. Not just the database
.mdb file, but the entire folder.

Open the database and go to Tools, Options, and Advanced Tab. Set the
Default Open mode to Shared and the Default Record Locking to Edited Record.
(While you are in the Options area, go over to the General tab and turn off
Compact on Close and Name AutoCorrect. Trust me on this.)

Make sure that the code in the FE is compiled then do a Compact and Repair
of both the FE and BE files.