Webmaster Forum / ASP / Database Access / January 2008

I get this error when accessing a MS access 2003 database from an ASP
page when the database is opened in Access on the backend. When the
database is not open on the backend it works fine!

-------------
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
-------------

How can I run the asp pages and have (anybody) open Access on the
backend at the same time?

The ASP page connects to the database as follows:

<%
Dim MM_hostingDB_STRING
MM_hostingDB_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=""D:\hosting.mdb"""

Dim RecordsetCustomers
Set RecordsetCustomers = Server.CreateObject("ADODB.Recordset")
RecordsetCustomers.ActiveConnection = MM_hostingDB_STRING
RecordsetCustomers.Source = "SELECT * FROM q_customers order by
customer"
RecordsetCustomers.CursorType = 0
RecordsetCustomers.CursorLocation = 2
RecordsetCustomers.LockType = 1
RecordsetCustomers.Open()
%>

Regards

Mel Christie