Databases
StackOverflow2013
Postsdbo
POUsing Access database for webpage, concurrent user issues
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing Access database for webpage, concurrent user issues
    text
    copied!<p>I have a simple access database that resides on a network drive. All of the people that need to make any modifications to this database have access on their machine, but they would like to have a read-only website just displaying the data contained in it. I set up a website and tried using the accessdatasource, and while I could connect, it had issues whenever a user had the database open in access. I swapped to using a sqldatasource with a connection string set up according to www.connectionstrings.com, but I seem to be having either the same or similar issues, depending on how I set up the string/database. Basically, the entire issue is, if the database is opened by any user, the webpage is prevented from opening the database. Is it possible to open the database read only from the webpage?</p> <p>It is an access 2000 database, but everyone is using copies of access 2007, and in all of these instances, the ASP.NET user has read/write access to the network directory containing the database, and read access to the database itself.</p> <p>When I use the connection string:</p> <pre><code>ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\&lt;source&gt;\&lt;database&gt;.mdb;User Id=&lt;USER&gt;;Password=&lt;PASSWORD&gt;;Mode=Share Deny Write;" </code></pre> <p>Where is not the default "admin" user, and is configured to have open/run (not open/exclusive) permissions on the database, I get the error:</p> <blockquote> <p>Cannot start your application. The workgroup information file is missing or opened exclusively by another user. </p> </blockquote> <p>As far as I can tell, there is no workgroup information file, but I am not really sure what I am doing there.</p> <p>When is the default "admin" user, I get the error:</p> <blockquote> <p>Could not use ''; file already in use. </p> </blockquote> <p>If someone has the database currently open, otherwise, it works fine.</p> <p>And finally, if I use the connection string:</p> <pre><code>ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\&lt;source&gt;\&lt;database&gt;.mdb;User Id=&lt;USER&gt;;Password=&lt;PASSWORD&gt;;Mode=Read;" </code></pre> <p>I get the error:</p> <blockquote> <p>Could not lock file. </p> </blockquote> <p>I have been googling this for the past several days now and I feel like I've just been going around in circles. Any insight at all would be appreciated.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload