I seem to be having a lot of problems with running/developing web site on my
XP Professional OS.
I have a simple web site (using ASP/VB), which retrieves information from an
Access 2000 database. I have MS Access XP installed on my machine.
When I open the database in Access and try to open up a page, I get this
error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
already in use.
After this error, I have to restart my machine, and as long as I don't open
the database again (in Access) it works fine.
If I take the same web site on a NT machine, running IIS4, it works like a
charm, even if I open the database in Access.
I found these articles on support.Microsoft.com and tried to apply the
solution, mentioned in it; but, no success:
http://support.microsoft.com/default.aspx?kbid=315456
http://support.microsoft.com/default...b;en-us;295297
the second article talks about giving permissions to a user. I gave
permissions to IUSER_MACHINE, and no luck.
I am using a DSNless connection and the database is local to the machine
Here's what I sue in ASP to connect to the database
set conn = Server.CreateObject("ADODB.Connection")
set rs=server.createobject("ADODB.Recordset")
mapPath="DBQ=" & server.mappath (db_path+db_name)
dbconnstr="Driver={Microsoft Access Driver (*.mdb)};" & mapPath
conn.open dbconnstr
Please help, I have to deliver this site for a demo, by tomorrow, for a
client.
--
Asim Chowdhry
Recursive Consulting
http://www.e-recursive.com