Compact and Repair Database

[sweetguy1only]

Hi all,

I have just become an Access database developer. I create Access
applications using Access run-time. I allow my clients to compact
their data file to maximize the performance of the applications. One
of my clients is complaining that they have some data lost after
compacting the database. Have any of you ever experienced the loss of
data after performing Compact and Repair Database?

Thanks in advance,
Monte

 

[SteveM]

Yes, it can happen. You should always do a backup before running it.

Same applies for your frontend when developing. ALWAYS do a backup before
decompile, compacting or using the Custom Startup Wizard etc.

Steve

 

[Maury Markowitz]

compacting the database. Have any of you ever experienced the loss of
data after performing Compact and Repair Database?

Oh yes. Access is pretty buggy in a lot of places, and, sadly, some of those
can led to (rare) data loss.

I have a startup function that makes backups of our app once a day. It's
come in handy

Maury