Compact and Repair Database

  • Thread starter Thread starter sweetguy1only
  • Start date Start date
S

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
 
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
 
[email protected] said:
compacting the database. Have any of you ever experienced the loss of
data after performing Compact and Repair Database?
Click to expand...

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
 
Back
Top