Access Connection

For all those of you with any more than my one app experience (whoo). What is the best method for connecting a stand-alone VB6 app to a Access 97 backend? Obviously, I need the Access tables to move with the app and the user might not have Access or ever had it? Appreciate any input.

If you have the access runtimes you can ship the DB with the VB app and it will work even if they don't have Access installed.

If you don't need to ship data with the DB ie. you just need the schema, then you can use ADOX to create the database on the fly. If you install MDAC with your app then you can create the database with ADOX and leveredge it with ADO without having access on the machine.

The user will be unable to open the access database with it's own gui in the last scenario.