I am using ADO Data Control and Access 2000 database file. I am setting the
properties of ADO data control at design time.
At run time I want to provide the user with the facility to reset the path
of the database file. so I copied the database file from its directory and
at run time I used the following statements:

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

Data1.Refresh

But when the form with the ADO control opens it gives an error saying that
it could not find the database file at the path specified at design time.
After this error the form opens and works properly.
I want to stop this error from appearing. (***** Problem 1 *****)

I am also using DataEnvironment in the same project for DataReports. I dont
know how to set the path of database file for DataEnvironment at run time.
(***** Problem 2 *****)