file already in use

[Jimbo Razza]

Hi There

I have a multi user database that has been split into a front and back ends. The front end sits on the users desktop and the back end is on a network drive.

Yesterday one of the users reported a message of "file already in use" when she tries to access it.

I've had her load new versions of the front end to her desktop and even tried to get her to run a version that is on the network. Neither ideas worked.

No one else is getting the problem and the only difference is that she is in a different location. (previous to yesterday however she had the same level of access).

 

[Derek Brown]

I don't have an immediate answer but my first thoughts would be that this could be a network configuration/drive mapping issue and it is being 'interpreted' by the code/process as file in use.
If the error is being generated from a VBA process, I would consider running the process in Debug mode to find out exactly where the problem is but first I would try using the Linked Table Manager in Access to re-link the front end database to the back end.