path of database in a variable

[mimiotoko]

Hi,
I have to start some reports with my VB-application. I use 2 different databases. One is on the local machine the other's on the server. One of this reports needs the connection to both databases. The path to the server-database is saved in the registry. Is it possible to start this report with a variable who includes the database-path?
It's important because I don't know where the User installs my application.

Best regards
Rainer

 

[MColeman]

Could you use an ODBC connection?

 

[mimiotoko]

Yes I can. The database is access 97.