I am running a small ASP.Net application on a windows 2003 server running IIS.
On my development machine (Vista Business) I used to develop the application I am able to simultaneously access the DB via both the ASP.Net web application hosted by the ASP.Net Development Server and MS Access. So I am able to change values in the DB using access and see the change reflected on the web site.
When I deploy the application to the 2003 server it seems IIS opens the DB exclusively. If I am running the web application then if I try to open the DB with MS Access I get message that the DB is opened in read only mode.
If I first open the DB in MS Access and then try and and use my web application I get the following error message from ASP.Net: Could not use 'C:\Inetpub\wwwroot\bbcint
'; file already in use.
Is there a configuration option to get IIS to open Access in a non-exclusive mode? The connection string I am using is as follows:
<add name="WWWD_Access" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Inetpub\wwwroot\bbcintllc\WWD\App_Data\BBC_WWD.accdb"