Hi I want to connect my asp pages to Access 2003, I am using the DSNless connection it works fine when I don’t put a password on my Access database.

When I put a password on my database I get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for


This is my connection string which I use to connect to Access:

MM_cnnDisertation_STRING = "DRIVER=Microsoft Access Driver (*.mdb);Dbq=C:\Inetpub\wwwroot\db\db1.mdb;PWD=pass word;"

My database is in a separate directory from my webpages

Any help would be most appreciated,

Rob

You need the Jet engine.

Try tis connection string

SConnStr= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\yourdata.mdb"

Cheers used the Microsoft Jet engine and it works fine

I'm very glad to help you.