Access losing db connections
- by Dwight T
I have a weird problem going on at work.
People have been using MS Access to connect to sql server db and lately people are getting sporadic problems with connecting to the servers. It's not always the same users and it's not always a problem, which makes it a real pain to try to solve.
One example of a related problem.
A person has a linked table to a table and she would filter the table or write a query on the table to return where itemsku = 'ABCD1234'. It would return one record but the ItemSku LMKN7486 and everytime it would return the wrong record but consistently the wrong record
so itemsku abcd1234 always returned LMNK7486
One would think it might be a driver problem, but it also could be a user problem. Just posting the question to see if anyone else has had similar senerios.
Thanks