Originally Posted by
ItsMe
The first thing I would do is make a new folder. Call it SAVE or something unique. Copy the current DB file and previous versions as well. Place different iterations of the file in a single location that you can keep track of.
Now go back to the problem child. Make sure there is not a locking file in the same location. Check for an ldb or an laccdb. Move (not copy) the locking file into your SAVE folder, if the locking file exists.
Now, make sure the problem child is not opening in exclusive mode by performing the following...
Open a different Access File, then... Go to File>Close to close the file you just opened and leave the application, Access, open. Move to the Backstage by clicking File, again.
From the Backstage click, Open>Computer>Browse.
From the Open Dialog Box, use the little down arrow (carrot) option next to the open button. Be sure to select the Open option. Do not select Read Only, Open Exclusive, etc.
Now close Access and test opening the file from one of the workstations.