<% ' Declare our variables... always good practice! Dim Con ' ADO connection Dim Record ' ADO recordset Dim strDBPath ' path to our Access database (*.mdb) file ' MapPath of virtual database file path to a physical path. ' If you want you could hard code a physical path here. strDBPath = Server.MapPath("DM.mdb") ' Create an ADO Connection to connect to the scratch database. ' We're using OLE DB but you could just as easily use ODBC or a DSN. Set Con = Server.CreateObject("ADODB.Connection") ' Opne the access database: Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";" ' Execute a query using the connection object. It automatically ' creates and returns a recordset which we store in our variable. Set Record = Con.Execute("SELECT * FROM ud") %>