I have created an app in Access97 with links to tables on SQL Server. When I try to refresh the links I get an error. I can refresh links from other apps to different dbs on SQL Server but something in this new db that I have created is causing problems. I created a test app to make sure it wasn't my app and it had the same problem with this db and was fine with others so it is definitely the tables in the db on SQL Server.
I am sure it is some simple setting that I need to change but what I don't know.