DSN-Less Connection

[admin]

Creating a DSN Less Connection to an Access database:

Conn = Server.CreateObject("ADODB.Connection")
DB = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath
("YOURDATABASE.mdb")

SQL = "SELECT * FROM yourtable"
DB.Open SQL, Conn
...
...

or something like:

<!-- #include file = "adovbs.inc" -->

SET Conn = Server.CreateObject("ADODB.Connection")
SET Rec = Server.CreateObject("ADODB.Recordset")

SQL = "SELECT * FROM yourtable"

Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\localhost\web\yourdatabase.mdb"

Rec.Open SQL, Conn, adOpenDynamic, adLockOptimistic
...
...