Hi,
I am currently developing a web application which will need to connect to a password protected Access database. Password which i set is "haha".
Below is the code which I had set for the connection part but it is returning me error saying that is is an invalid password. Is there anything which might have missed out?
dim strCnn
dim Cnn
'Establish a connection to the database
set cnn = server.createobject ("ADODB.Connection")
strCnn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Server.MapPath("LockTest.mdb") & ";Uid=;Pwd=haha;Mode=3;"
Cnn.open strCnn
Thank you.
Cheers,
froggy
I am currently developing a web application which will need to connect to a password protected Access database. Password which i set is "haha".
Below is the code which I had set for the connection part but it is returning me error saying that is is an invalid password. Is there anything which might have missed out?
dim strCnn
dim Cnn
'Establish a connection to the database
set cnn = server.createobject ("ADODB.Connection")
strCnn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Server.MapPath("LockTest.mdb") & ";Uid=;Pwd=haha;Mode=3;"
Cnn.open strCnn
Thank you.
Cheers,
froggy
