ADO Data control 'database not found' error

[culshaja]

When I load a form I get a 'database not found' error if I have the database in a different location from that originally developed in. This is due to the control initialising and looking for the database before the form initialise and load events occur. In the form load or initialise event I then reset the connection string argument and refresh the data control and its ok. How can i stop this initial error?<br>
<br>
James

 

[ACC]

I think you can use &quot;On Local Error ...&quot; <br>
check the number of error with Err.Number <br>
<br>
Bye

 

[Nancy]

You can set the data control properties in code.

 

[culshaja]

I set the data control properties in code, but the control initialises before any events fire, so that the error occurs before I can do anything.<br>
<br>
James <p>James Culshaw<br><a href=mailto:james_culshaw@activedatasolutions.madasafish.com>james_culshaw@activedatasolutions.madasafish.com</a><br><a href= > </a><br>