I have a database "MPD_beSQL" on a SQL server "mcpws02/sqlexpress". I created an MS Access runtime frontend with MS Access 2010. I use windows authenication and have the users setup under Security|Login.

It's set to allow connections through TCP port 1433 and a System DSN connection is setup.

This works great when installed on most machines. However, when installing on Citrix as a desktop app for multiple users and setting up the DSN, we get an error.

Attached is the error.

Any ideas???

Have you created the DSN on each Citrix Server? If so, does the TEST CONNECTION return a success? If not, you do need to set up the DSN on each Citrix machine.

When checking the test connection on the DSN, is when we get the error. So it sounds like it needs to be setup on each machine. I'll give this a try.