Changing database file location

[Nopps]

I've created a program, and it requires a database (in Microsoft Accessif it matters) for some information. But, when I change computers, I have to change the location of the database in the program.
The only way I can think to fix this problem is to create a installer program to copy the file to a location, record where it was installed and put that location in the database access field.
Is there an easier way to do this? It would really help me out.

 

[sunaj]

Hi,

The easiest is of course if the database is located in the same dir as the program, alternativly that the path is given relatively to the app.path
Or: You must know which directory the intallation program installs the database to, this information can be added to your program...


Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[CCLINT]

Or, set the database to a DSN and then you only need to add the DSN with the same name on the client PC.

 

[Nopps]

Thanks, i'll try both of those.

 

[Guest_imported]

Think Think,
There is a better way some-where.