• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Using ADO to open an Access MDB DSN-less.

Using ADO to open an Access MDB DSN-less.

Using ADO to open an Access MDB DSN-less.

Rate Using ADO to open an Access MDB DSN-less.

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

       Dim RS1 as New ADODB.Recordset
       Dim sSQL as String

       CN1.CursorLocation = adUseClient
       CN1.Provider = "Microsoft.Jet.OLEDB.3.51"
       CN1.Open App.Path & "\MyDatabase.MDB", "", ""
       
       sSql = "Select * From Address Order By [LName]"
       RS1.Open sSql, CN1, adOpenDynamic, adLockOptimistic, adCmdText