I have an MS Access app (.mdb) on a Citrix server dynamically connecting to one of three SQL DBs depending on the particular assignment of the logged in user. All users use the same .mdb in Citrix.
When a user logs in the app determines which SQL DB the user should connect to and re-establishes the links to that SQL DB.
However, each time a new user logs in the ‘relinking’ occurs for all users to the same DB assigned to the newest logged in user. So all currently logged in users may or may not be connected to his / her respectively assigned DB.
The ‘relinking’ complicates things further by disconnecting already logged in users from their DBs and any data edits currently in process fail with ‘ODBC connection failed’ errors.
So, is there any way that a single .mdb can allow dynamic and unique connectivity to the various backend SQL DBs without adversely affecting other users logged into the same app?
I’ve read on this site where some apps will copy the .mdb to the user’s own machine at login but that would not work here because the users, app. and SQL DBs are all in different states (USA). That’s why we use Citrix.
Thanks for your help / suggestions.