Access 2010 database with linked tables to a SQL Server 2005 DB.
Created a System ODBC connection to linkg 3 tables.
Using a DSN-less vba sub routine to link the tables at startup without needing the ODBC System DSN (Code to the Routine can be found here http://www.accessmvp.com/djsteele/DSNLessLinks.html
Everything was working fine for about 2 weeks.
Now when I try and save a record it states there is a Write Conflict (which I know is not true).
When I try to go straight to the tables or the query it says "Connection failed" User is not associated with a trusted connection.
Since I am providing the userid and password in the Sub Routine, why am I now having this problem.