May 15 2012, 11:22 AM
Lately, I have been experiencing a very long response time when extracting data from one of our database, while the other databases used in our deparmtent are running fine and without delay. When creating queries or reports, it seems to take makes minutes before I can see the results. I know there is a lot of data stored in the database when compared to one of databases that I created but in comparison to another database the amount of information stored is about the same and there is no delay with that database.
Couple of things. Can the amount of data in an Microsoft Access Database cause it to be slow? I've tried moving the database to another drive to see if that would change anything - it didn't. We are always "backing up" the database every Friday before leaving for the weekend and it still has a slow response time on Monday. I have search for reasons for the delay and have been unseccessful why this happening.
Could anyone please assist?
May 15 2012, 11:30 AM
More data means longer response, but all in context. if we are talking 10000's of records it is one thing, if we are talking 1000000's records it is another.
- Have you properly indexed your key table fields, those which are used a criteria within your queries?
- Do you have a persistent connection established to your back-end?
- Have you performed a Compact and repair on your databases? (make a backup first just in case)
- Is Track name AutoCorrect Turned off?
- Are your Subdatasheet Name set to [None]?
- Is your OS fully up to date?
- IS your Office/Access installation fully up to date?
- In general terms, is your network usually responsive or do you experience lags when trying to access files, folders, ...?
You may also like to review:http://www.granite.ab.ca/access/performancefaq.htmhttp://www.fmsinc.com/microsoftaccess/performance.html
May 15 2012, 11:38 AM
Our networks usually vey responsive with very limited delays.
May 15 2012, 11:50 AM
You have implemented all of the above?
- Your database is split?
- The Front-end is located on your local PC? Each user has their own copy?
- Have you tried reimporting all your FE objects into a new fresh db to see if it might help?