Connection to Access db problem

[bbpitpit]

hello,

I have a problem in the connection to my db, and this is my connect.asp code

<%
DIM objConn  'holds the database connection object
 
'create ADO connection
Set objConn = Server.CreateObject("ADODB.Connection")
 
objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/mydata.mdb") & ";PASSWORD=1234"    
 
%>

I've open permission on my register key in ODBC, and already checked all the password for my database...all correct, nothing wrong, but when I test my website in localhost, it gave me the ERROR:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.

I'm nearly give up, and already search for the solution in internet and tried out all the suggested solution but it still gave me the same result. Anyone please advise me what to do/configure next?

Thank you very much.

[MMcCarthy]

Try this ...

<%
DIM objConn  'holds the database connection object
 
'create ADO connection
Set objConn = Server.CreateObject("ADODB.Connection")
 
objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/mydata.mdb") & "; User ID=; PASSWORD='1234'"    
 
%>

[bbpitpit]

still the same error accur.....Any other solutions? Or do I need to check my IIS configuration or..??? Anyone can list out a checklist of ODBC setting or Access setting or IIS setting?

This problem start after I reformatted my computer and re-install my MS. Access and also IIS.

Somebody...HELP PLEASE......!!!!!

[MMcCarthy]

Open a blank Access database.

Try to create an odbc connection to the aforementioned database by linking to the tables.