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.