Parse UID and Password from access form

[Brice Rowe]

Hi All

I have just upgraded the data back end of an Access project to MySQL using ODBC to link the tables.

I want to know if there is a way to send the UID and Password of the MySQL database from access to prevent the MySQL ODBC Connector Screen from popping up for authentication. I have my own User security setup in the front end so I just want access to all the linked tables when they enter their personal user and password information at the front end login. I prefer not to write ADO connection strings for every form data source or query.

I hope I have explained this properly

Kind Regards
Brice