The following code is erroring out on my Windows XP machine when trying to access a MS Access 2000 database.

Dim objConn
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
                    "Data Source = C:\Datastores\Home Notes.mdb"

The error that I'm getting is:
Error Type:
Microsoft JET Database Engine (0x80004005)
Unspecified error
/project/Datastore.asp, line 4

Line 4 is the objConn.Open statement.

I tested this code out on a Windows 2000 machine and it runs fine. I have also verified that the IUSR_xxxxx account has write access to the folder where the database is stored.

Can any one help.

Thanks

CO

Hmmm, odd. This should work.

What are the access permissions for the database and the folder (Other that write access for the Datastores folder)?

Under what account is IIS running? Are you using anonymous access? If not the logged on user needs permissions as well.

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Isn't it that Open is a method and not a property, and therefore should be like this... Jacob.

Whoops, missed that.

Funny things is, I pasted the sample code in a test page, followed by:

If objConn.State = adStateOpen Then
  Response.Write("Open")
Else
  Response.Write("Closed")
End If

and it wrote Open......

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Both IUSR and the account that I'm logged with have full access to the database folder and the database file. There is not any security set up on the database it's self. I ever tried logged in as the workstation administrator and it still is not working.

Have you verified that you have Jet 4.0 installed on your machine?
As an alternate, please give this connection string (ODBC) a try:

For Standard Security:

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
           "Dbq=C:\Datastores\Home Notes.mdb;" & _
           "Uid=admin;" & _
           "Pwd="

Found at:
http://www.able-consulting.com/ado_conn.htm

You dont have jetinstalled in your machine. i had the same problem. When i tested my kode it did not work, but it worked great after i uploded it to brinkster
ayhan

One more thing. You may have put wrong path dor your db. Check it again and put _ between home and notes. make the same changes in your file db section