Corrupted db - Part 2

S

SAC

In this app one of the computers is left on 24/7. It has a frontend linked
to a backend.

The IT dept is telling me that since the file was open their backup software
did not back it up. Isn't there backup software that backs up busy files?

Thanks.
 
A

Allen Browne

No. You cannot reliably back up an Access database while it is in use.

Typically people either schedule a time when the database can be closed, or
use a larger database such as SQL Server if 24x7 is essential.

Of course, you can execute an Append query while the database is in use, so
another technique is to export the data to a backup file by executing a
series of Append queries.
 
Top