I am using a MS Access 2000 to store my info for my in development website -- <!-- m --><a class="postlink" href="http://www.randominc.org/default.php">http://www.randominc.org/default.php</a><!-- m --> -- If I open two browsers and hit it at almost the same time, one of the browsers fails, spitting out the following error:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use., SQL state S1000 in SQLConnect in d:\sites\randominc.org\news.php on line 2
I looked all around and couldn't figure it out. Then I checked the current version of the website [http://rand0m.hpi.net] and if I hit it at the same time on that one, it gives the same error [though hidden by the black background]. Both of them access the db through a System DSN via ODBC.
My thinking is that MS Access does not allow multiple concurrent connections to the db. Does anyone have info regarding this? Any idea on how to allow the db to allow multiple browser connections?
Thanks!
Randal
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use., SQL state S1000 in SQLConnect in d:\sites\randominc.org\news.php on line 2
I looked all around and couldn't figure it out. Then I checked the current version of the website [http://rand0m.hpi.net] and if I hit it at the same time on that one, it gives the same error [though hidden by the black background]. Both of them access the db through a System DSN via ODBC.
My thinking is that MS Access does not allow multiple concurrent connections to the db. Does anyone have info regarding this? Any idea on how to allow the db to allow multiple browser connections?
Thanks!
Randal
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->