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.
(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"
This is The Code to Open and Connect to a Database of MicroSoft Access 2000 /XP etc. Comments
No comments yet — be the first to post one!
Post a Comment