Opinion Poll ~ Compact/Repair on Server

[mtairhead]

I realize that this issue has likely been beaten to death in past threads; my recent participation in one brought this issue to light.

Can I get a general feeling from participants concerning the dangers involved in the practice of compacting and repairing databases on a server? I greatly respect the advice I get from these forums, and those who give it, however there seems to be some disagreement between people on this issue.

If there is a danger of loosing records, why does this occur? Are there versions of Access where these problems are solved? Do you think that frequency of use, or volume of data have anything to do with the risks?

Thank you all!

Andrew

 

[ghudson]

I have never had a problem with compacting a db [Access 97 or 2003] on the network. Most of my db's are split with the back end on the server. The db should only be compacted when needed. I have posted code to only turn on the Compact On Close option if the db exceeds my preset file size.

 

[mtairhead]

Your code is in my database. I never thanked you in the previous thread - So thanks!

Andrew