ODBC Connection

[peggypph]

I develop Access program which will access the backend MySQL database. I use ODBC connection under Windows which defines DSN. When I move my program to anther client PC, I define same DSN name under Windows ODBC with different IP. But the Access front end program ask for re-entering DSN information after each time start up.

Is there any method that can automatically link correct ODBC? I don't mind to reconfigurate at the first time, but it is annoying if we have to reconfigurate ODBC parameter every time. Or may I define the connection string on a local file/MS access table, that the ODBC connection can be configure from the table.

Thanks for help!

From Peggy Poon

 

[KenHigg]

Peggy, See my post in the SQL Server forum titled ' ODBC COnnection'. There were several great solutions. One hurdle I can't seem to get past is the need for the user to have to enter the username/pwd for the odbc/sql connection. I would like to embed these if anyone knows how...