Could someone explain the best way to establish a DSN-less connection to an Access DB outside of the web root where the ASP file referencing it is located? I have dug through most of the tutorials and forum postings but can't seem to make the connection. Here is the code I have:
Dim adoCon, dbPath
dbPath = "c:\test\cropleads.mdb"
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & dbPath
If I change the dbPath variable to the DB withing the ASP file's folder it works.
Thanks,
Topic Options
Post Options
Thanks(0)
