PDA

Click to See Complete Forum and Search --> : Database connectivity


Jan 25th, 2000, 02:42 PM
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?

Inhumanoid
Jan 25th, 2000, 05:11 PM
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]