We have had an Access database running for some years mostly with SQL-Server backend data connected using ODBC. Each user has their own front end. Since Monday accessing the SQL data has become extremely slow - so that it's unusable by users. We can't see that anything has changed - no windows/ server updates.
SQL is returning data very quicky. There are a couple of Access tables linked too & they still open very quickly too. We still have other databases where the backend is in Access all running on the same server & they are all still running as before.
I 'feel' like it is the ODBC connector which is causing the slow down, but don't know enough or how to prove/ test / fix it.
I've checked the ODBC 'Start Tracing Now' & 'Machine Wide tracing for all user entities' & both are unticked/off.
Any suggestions - I'm stumped & have a lot of users not able to work?
Thanks
Jane
_._,_._,_
Groups.io Links:
You receive all messages sent to this group.
View/Reply Online (#116510) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]
_._,_._,_
Tidak ada komentar:
Posting Komentar