ADO Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to connect to an access 2003 database in an ASP page with the ASP code below.

<%
Dim objConn
Dim objRS
Set objConn = server.CreateObject("ADODB.Connection")
objConn.ConnectionString="Provider=MICROSOFT.JET.OLEDB.4.0;User ID=Admin;DATA SOURCE=C:\Documents and Settings\UserId\My Documents\My Data Sources\HTTracker.mdb"
objConn.Open
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "FuelPurchases", objConn, , , adCmdTable
objRS.MoveFirst
Do While Not objRS.EOF
Response.Write objRS("StopName") & " " & objRS("City") & " " & objRS("State") & "<BR>"
objRS.MoveNext
Loop
%>

Once I open the page I get the following error


Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'C:\Documents and Settings\David Cook\My Documents\My Data Sources\HTTracker.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Please help if you can.
 
Make sure that the ID under which IIS is running (typically
IUSR_machinename) has read, write and delete permission on the folder
C:\Documents and Settings\UserId\My Documents\My Data Sources\

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Dave said:
I'm trying to connect to an access 2003 database in an ASP page with the ASP code below.

<%
Dim objConn
Dim objRS
Set objConn = server.CreateObject("ADODB.Connection")
objConn.ConnectionString="Provider=MICROSOFT.JET.OLEDB.4.0;User
Click to expand...
ID=Admin;DATA SOURCE=C:\Documents and Settings\UserId\My Documents\My Data
Sources\HTTracker.mdb"
objConn.Open
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "FuelPurchases", objConn, , , adCmdTable
objRS.MoveFirst
Do While Not objRS.EOF
Response.Write objRS("StopName") & " " & objRS("City") & " " &
Click to expand...
objRS("State") & said:
objRS.MoveNext
Loop
%>

Once I open the page I get the following error


Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'C:\Documents and
Click to expand...
Settings\David Cook\My Documents\My Data Sources\HTTracker.mdb'. It is
already opened exclusively by another user, or you need permission to view
its data.
 
Back
Top