Hi, I have been tasked with troubleshooting some user-created Access front-ends that are running slowly. I would understand if just queries and reports were taking a long time to run, but simple linked tables are taking over a minute to show up.
When I create an Access database from scratch and link to one of the problem tables, it shows up write away, but when I create a new linked table to that exact same table in one of the user-created DB's I'm waiting and waiting for it to load.
My question is this: is this expected behavior? Does it make sense that the "same" linked table would perform differently in two different Access front-ends? And if not, what are the possible problems with the way that the slow front-ends are set up?
Note we are using SQL Server directly as an ODBC datasource on all of these.
Thanks for your help!