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

by Syed Zulfiqar Ali Hussain Rizvi (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Unknown Difficulty
Originally Published: Thu 7^th February 2002
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

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



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"

Download this snippet Add to My Saved Code

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

No comments have been posted about This is The Code to Open and Connect to a Database of MicroSoft Access 2000 /XP etc.. Why not be the first to post a comment about 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. Comments

Post your comment

Difficulty