-
How do I get my game program to automatically set any workstation's ODBC 32-bit to use the game's MS Access database as a datasource? I wanted to let some friends at work play my multi-choice trivia game, but I don't want to have to go to each PC & manually set the ODBC on the control panel to the game's database. Can ADO do this?
-
Just go to Project -> references.
Check ms DAO 3.6 Object Library ...
No you're all set up.
[CODE]
Dim db As Database
Dim rs As Recordset
Set db = DBEngine.OpenDatabase(App.Path & "\<your.mdb>")
Set rs = db.OpenRecordset(<Use some SQL here> )
[\CODE]
