Software

Ask something
Discussion Locked

Access database slowdown

0 helpful
7 replies

by sharon_severson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
My company is using an Access database to keep track of donors and donations. Within the past couple of weeks, the database has become incredibly slow (around 10 minutes) when switching from one form to another. It appears to have started after it was opened (but no design changes made) in a computer running Windows 2000 and Office XP. Most of our systems are Windows NT and Office 2000. I have run a detect and repair on the database, but it did not correct the problem at all.

7 replies

by theresa jones

Actually I've run into the same problem myself and an update to SR-1 of Office 2000 without the intervention of Office XP. What happened before I applied the patch was that the database kept getting larger and larger each time I closed it. This was especially prevalent when I had the db on removable media and was using the 'compress on shutdown' feature. I suspect that Office XP did some 'conversion/upgrade' work on your database that has rendered a similar type of corruption. My best suggestion to you, albeit not what you probably want to hear, is to restore your backup from the last date prior to the XP incident. This is also reminiscent of a problem from the old days that if you took a floppy with data on it from a Win95 machine and even just stuck it in the drive of a Win98 machine, it's mbr would get corrupted. Windows products are WOEFULLY not backward compatible in that regard.

by itpreneur

Has your database grew larger? Remember, access will can't handle such a large database it has a maximum limit of more than 125,000 records with a maximum 255 data field. It will definitely slowdown your access. I advise you to migrate to SQL SVR 7.0 for improvement and data handling for your database since the technology is at far with Access using only Jet Engine.

This discussion is closed to new replies.