Corrupted db - Part 2

  • Thread starter Thread starter SAC
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data conflict? 5
MDE possible corruption? 3
Need a little advice on frontend - backend set up... again. 1
Access Access 2010 Backend DB Backup/Restore 0
Best Tool to Repair Corrupted PDF Files 0
tinkering with split databases 0
Network Share 1
can't open front-end exclusively 1

Back
Top