is there any way to select the MS Access DB at runtime? The best I could do was to change the DSN in ODBC and use that DSN. I'm hoping there would be a more elegant sollution to this. I'm currently using MDBs to transfer old databases from clients to SQL db's, but having to change the DSN for every transfer is pretty time consuming.
Thanks in advance.
Thanks in advance.