ADO connectionstring

[JasonS]

Does anyone know how I can get around having to set the ConnectionString at design time for an ADO control?
My application can use different Access databases and I prompt the user to select the correct database.
In the load section of the form I programmatically set the connection string. However, ADO tries to establish the connection to whatever is in the connection string at design time before the Load code is executed.

[Clunietp]

I've gotten around that by deleting the connection string property of the ADO data control at design time. In the form_load event, I set the connection string and all is good