Drastic Access slow down (XP SP-1)

[Peter Kinross]

Any idea what can suddenly, drastically, sow down an Access app. The app uses an Access replicated back end and 2 different non-replicated Access front ends (Different apps using the same data). Both have slowed by a factor of 30

[johnhutchison]

I have twice had similar experiences with Access 2000 databases. ( Not involving replication)

The first time, I tried a range of things to fix the problem without success. Eventually, converted back to Access97, then reconverted back to Access 2000 and it has been fine ever since. Fortunately, there was nothing that didn't work in 97 in the database.

Next time it happened ( with a different file) , it did it again, and worked again.

Another thing to try would be to decompile the database, then recompile. There have been posts about how to do this - open the database with a shortcut with /decompile added to the end.