Connecting to Access

[lomano]

I am having a minor problem connecting to Access through an ASP page.. I think this is because i have a password on my access database, that seems to be the indication of the error.. How do i get around this?

<%
'Set variables for opening database connection
Dim connString
Dim MyConn

'Create connection to database using Access Driver (Doesn't display memo fields)
Set MyConn = Server.CreateObject(&quot;ADODB.Connection&quot
connString = &quot;DBQ=&quot; & Server.MapPath(&quot;db3.mdb&quot
MyConn.Open &quot;DRIVER={Microsoft Access Driver (*.mdb)}; &quot; & connString
%>

 

[swilliams]

There should be other parameters you can put on the connection string, like UID and Password.

Simon

 

[culshaja]

If I remmber correctly you need to use:

connString = "DBQ=" & Server.MapPath("\db3.mdb")

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305