In our environment multiple users each work with their own copied front-end, with tables linked to a single networked back-end (both files are .mdb).
Each user has permissions to read and write to the location of BE, and both FE and BE are set to "shared access".
Recently a single user started getting error: 3045 "Could Not Use Database; File Already in Use" while trying to open forms using linked data.
The same error appears while trying to re-link the tables using the manager. All other users can still normally work.
Tried restarting his workstation, removing local files and re-copying the FE and it didn't work.
There is no .ldb file left after all users turn off the FE, compacting after that and restarting the FE of the unlucky user didn't help either.
Said user is working on AC2010, but some others are working on AC2007 and AC2003.
Please help!
edit: BE is stored on Windows Server 2003.
Best Answer
Turns out the problematic user could create new files and delete them in the location, but did not have permission to delete files made by other users due to changes made by our IT.
As such the problem is now resolved.
Thanks to everyone who read and sorry for taking your time.