Replica Size spiralling out of control

[efinnen]

I have a split database, and the replica on

April 2 was 19 meg
Then was merged
May 2 was 19 meg
3 months have passed, not a significant amount of data has been added (realistically 1-2 meg) and the replica has spiraled out of control (up to 300meg). I have tried to compact and repair the replica, to no avail. I don’t know where this bloat exists, anybody have suggestions for the current one or precautions for next time?

Any help or guidance would be appreciated.

Thanks
Eric Finnen
[sig][/sig]

 

[jagilman]

Just a thought, Access has an un documented switch called decompile. I have used it to fix problems. Make a copy of the front end database you are having trouble with. Then try the following. click start, click run, type this without the quotes "msaccess /decompile"
Access will open like normal, open your problem database, you should get a message about the code being decompiled. Close Access. Open Access like normal. Get into a code window for any form. Recompile and save all modules. Then try your database again. This could help.

This suggestion came from the VB Advisor magazine.
[sig]<p>John A. Gilman<br><a href=mailto:gms@uslink.net>gms@uslink.net</a><br>[/sig]