• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• This is The Code to Open and Connect to a Database of MicroSoft Access 2000 /XP etc.

This is The Code to Open and Connect to a Database of MicroSoft Access 2000 /XP etc.

This is The Code to Open and Connect to a Database of MicroSoft Access 2000 /XP etc.

Rate This is The Code to Open and Connect to a Database of MicroSoft Access 2000 /XP etc.

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

Conn.Provider = "Microsoft.Jet.OleDb.4.0"
Conn.ConnectionString = (App.Path & "\Accounts.mdb")
Conn.Open

Set Rs = New ADODB.Recordset
Rs.CursorType = adOpenDynamic
Rs.LockType = adLockOptimistic
Rs.ActiveConnection = Conn
Rs.Open "Select * from Acc_Heads"