Help Me Fast...please

[gayomard_mehta]

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.........

[RobDog888]

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.

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