MySQL Forums
Forum List  »  Connector/ODBC

Parse UID and Password from access form
Posted by: Brice Rowe
Date: April 29, 2018 03:31AM

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

Options: ReplyQuote


Subject
Written By
Posted
Parse UID and Password from access form
April 29, 2018 03:31AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.