Access File DSN Trusted Connection setting ignored

I have an MS Access application that currently connects to a SQL Server instance using Trusted Connection via the following file DSN settings:
[ODBC]
DRIVER=SQL Server
Trusted_Connection=Yes
DATABASE=APUB_MARTY

APP=Microsoft Data Access Components
SERVER=server.domain.com

I am trying to disable Trusted Connection by simply removing the " Trusted_Connection=Yes" line. However, when I build the .accde application using the new file DSN, the application still uses Trusted Connection, apparently ignoring the new configuration.

Any ideas on this confusing behavior? Thank you in advance.

0 answers