I have an Access database that previously had linked tables to Oracle. With our Oracle retirement, these tables have to be relinked to the same tables that have been migrated to SQL Server 2008. A file DSN with SQL Server login and password is provided to users for this purpose (same login and password as Oracle), and works.... once. When they close and reopen Access and try to open a table, they get an ODBC error because they don't have access via Trusted Connection. The sql login and password information evaporates.
If I uncheck Trusted Connection and type in the sql login and password, it works until the next time Access is opened.
How do I get the login information to stick?