I have an MS Access application that currently connects to a SQL Server instance using Trusted Connection via the following file DSN settings:
APP=Microsoft Data Access Components
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.