I have an Access 2007 application that uses the SQL ODBC driver. When setting up the connection to the sql db, there is a check box that says 'Use trusted connection'. If I check that box, package the application, and run on a new (different) WIN10 computer it will not allow the applications query to run (error 2950).
If I uncheck the box, package the application (second version), and run on a new (different) WIN10 computer it works!
Now if I run the second version on the WIN10 computer that has the SQL db local, it will not allow the applications query to run (error 2950).
If I run the first version (Use trusted connection checked) it works!
How can I have one version that runs on both computers?
If I uncheck the box, package the application (second version), and run on a new (different) WIN10 computer it works!
Now if I run the second version on the WIN10 computer that has the SQL db local, it will not allow the applications query to run (error 2950).
If I run the first version (Use trusted connection checked) it works!
How can I have one version that runs on both computers?