I have an Access DB with a few ODBC links to some tables in an external 3rd party My SQL DB. I'm able to use a similar ODBC connection to this same SQL db with Crystal Reports and multiple users have no problem running their Crystal Reports.
However, Access is only allowing me to configure one PC client to have the ODBC trusted connection work... if you try to configure a 2nd PC, it becomes the one with the allowed connection, and the 1st PC no longer works.
Can anyone tell me the clue to making ODBC using trusted connections work for multiple users in the same database?
Thanks!
However, Access is only allowing me to configure one PC client to have the ODBC trusted connection work... if you try to configure a 2nd PC, it becomes the one with the allowed connection, and the 1st PC no longer works.
Can anyone tell me the clue to making ODBC using trusted connections work for multiple users in the same database?
Thanks!
