Hi guys,
my database is too slow if i click any form or query it is taking more than 5mins i have more than 20thousan records in my database & it is a multi user. is there any option make my database to run fast....
please help me to rectify it....
Hi guys,
my database is too slow if i click any form or query it is taking more than 5mins i have more than 20thousan records in my database & it is a multi user. is there any option make my database to run fast....
please help me to rectify it....
20,000 records is not much.
Is this a split design with each user running their own copy of frontend?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
S its an split design with each user running their own copy of frontend....
We had this condition happen because of the anti-virus on the network. It sucked ALL our computing resource on the db.
is there any option to make my database to run fater/normal....?
It could be many things....
It could be the network,
or db connection
or anti-virus (if you can disable it temporarily)
or db usage on other users.
Conduct tests.
1. Copy of frontend and backend on a computer at C: root. Change table links to this backend.
2. Make copy of frontend and import data into local tables. Run this db on computer C: drive.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Here's a link to several suggestions: http://www.granite.ab.ca/access/performancefaq.htm