Here's the deal, and I hope someone can help me find an answer:
I have an access front end to a MSSql database. There is a form that users can use to input data. All permissions are handled by the SQL database, except, of course for the ODBC driver. That driver is set with a specific credential. All users access the Access front-end via terminal services to a specific server that automatically runs the front-end.
When an admin logs in, the add form works perfectly, but when a normal user logs in, the ODBC goes nuts and asks for log-in credentials for every field in the form. It keeps trying to use trusted connection and it does not seem to be trying to use the ODBC connector that was set up.
Can someone assist me?
Thanks.
-Scott
I have an access front end to a MSSql database. There is a form that users can use to input data. All permissions are handled by the SQL database, except, of course for the ODBC driver. That driver is set with a specific credential. All users access the Access front-end via terminal services to a specific server that automatically runs the front-end.
When an admin logs in, the add form works perfectly, but when a normal user logs in, the ODBC goes nuts and asks for log-in credentials for every field in the form. It keeps trying to use trusted connection and it does not seem to be trying to use the ODBC connector that was set up.
Can someone assist me?
Thanks.
-Scott
