Help Me Fast...please

I have an application in Visual Basic 6.0 and linked it using ado to an access database.I have created a setup file for the project.Now if I set the file up at a different location than that specified n the ADO data control it gives an error.How to search for the location of the access database at runtime.Please help me....fast....please.........

Welcome to the Forums.

In your connectionstring do you have the path to your database hardcoded?

You need to use a commondialog box control to allow the browsing. Thentake
the selected db and path and you would place it in a connection string like
this and then open the selected db.
Ex.

Code:

---

Cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";Persist Security Info=False"

---