OLEDB Provider Connect String for Jet/Access

If you know the path to the MDB (using ASP)

<% ' ASP server-side code
      oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\myDb.mdb;"
%>
 

If you don't know the path to the MDB (using ASP)

<% ' ASP server-side code
      oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(".") & "\myDb.mdb; User Id=admin; Password="
%>

Add Feedback