Location independant database HELP !!!

[VBfreak]

I am making a program that I want to be location independant. I mean that you can drop the application and the database in the same directory and that the application when starting will look in the same directory as it is to find the database and connect to it. I am using ADO and am connecting manually to the database. Thanks!

[VBfreak]

Thanks MartinLiss it's an even better idea than what I had althought mine worked. All I had to do in the connection was to write the name of my database in the Source parameter and it will connect to it automaticaly!

[DatabaseLife]

Why not use a UDL file?

[VBfreak]

It's because I can't use any of those and I figured it out so thanks for the effort!

[MartinLiss]

App.Path will give the path where your program is running so if your database name is "MyDB.MDB", then strPath = App.Path & "\MyDB.MDB" will yield the path.

------------------
Marty
What did the fish say when it hit the concrete wall?
> > > > > "Dam!"