Microsoft JET Database Engine error '80004005' Could not use ''; filealready in use.

[Mel]

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

 

[Bob Barrows [MVP]]

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!

All users of the database file need to be able to create, modify and
delete a locking file that has a .ldb extension in the folder that
contains the database file. This means that users need Change/Modify
permissions for the folder, not just the .mdb file. Who the users are
depends on what type of authentication your website is using. If using
Anonymous, then the IUSR_machinename account requires permission for the
folder. Otherwise, all the accounts of the users themselves need the
permissions. See:
http://support.microsoft.com/default.aspx/kb/253604
http://support.microsoft.com/default.aspx/kb/166029
http://support.microsoft.com/kb/253580/EN-US/


Once the permissions are correct, you will be able to have the database
open in Access while running web pages that also use it.

 

[Mel]

All users of the database file need to be able to create, modify and
delete a locking file that has a .ldb extension in the folder that
contains the database file. This means that users need Change/Modify
permissions for the folder, not just the .mdb file. Who the users are
depends on what type of authentication your website is using. If using
Anonymous, then the IUSR_machinename account requires permission for the
folder. Otherwise, all the accounts of the users themselves need the
permissions. See:http://support.microsoft.com/defaul...http://support.microsoft.com/kb/253580/EN-US/

Once the permissions are correct, you will be able to have the database
open in Access while running web pages that also use it.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

That fixed everything thanks!

Mel