what's the best way to set my database?

[nutstretch]

I am writing an application which relolves around a database.

At present i am setting my database as

set db as opendatabase(app.path & "\db.mdb")

hen i am finished with this project i want to create a setup file to set this up on another machine. Am I ok putting app.path or should i state where this database should be.

when the setup file is used I am presuming that I then physically put the new database with the project

Please can someone clarify

I will be using the same name of database as in the project just a virgin one.

Many thanks

[Clunietp]

You will have the option of where to put your database file from the setup program.

You are fine using App.Path as long as you keep the DB in the same dir as the EXE, and your users keep the DB in the same dir as well

[nutstretch]

Many thanks for that Clunietp. I did not want to do it all and then find all my database sets had been written wrong

Nuts