By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,046 Members | 2,058 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,046 IT Pros & Developers. It's quick & easy.

problems with connecting to Access dB

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.