Slow performance if I don't compact/repair

A

access_goat

Access 2000 Sp3/Win XP Sp2/MDAC 2.8 SP1/SQL Server 2000 BE/FE is on a network
share.

This problem is repeatedable only on one workstation.

If I open the FE normally performace is sluggish, delays when clicking
command buttons/drop-downs and lengthy calculations when advancing to the
next record. If I compact/repair the database perfromance returns to normal.
If I exit and re-open without compacting/repairing performance degrades again.

I only get acceptable perfomance after compat/repair. Please help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 "compact and repair" asking password 0
Cannot compact and repair a database 5
compact & repair 3
compact and repair database 3
Unable to compact/repair because I have it opened 8
Access 2007 Compact and Repair 0
Conversion Advice 1
Error during compact and repair database 1

Top