This is the scenario:
I have a maintenance office that has been using an Access 2003 system to track work orders. The backend database resides on the network and we have installed the frontend on the users’ PCs.
I have added a .aspx form to the company’s intranet site so they can submit work orders there. I moved the Access backend DB from its current network location to the web app server and was successful at connecting the web form to it. I was also successful at linking the frontend DB to the backend DB in this new location. However, when someone is in the thick client app (the maintenance office) the web form crashes and says :
Server Error in '/' Application.
Could not use ''; file already in use.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Could not use ''; file already in use.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Has anyone solved this kind of an issue?