Results 1 to 2 of 2

Thread: Database connectivity

  1. #1
    Guest

    Post

    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?

  2. #2
    Hyperactive Member
    Join Date
    Oct 1999
    Posts
    309

    Post

    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]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width