Back-Up Questions

K

kraasty

Hello everyone

1. Can I have the database take back-ups and/or compact and repair itself by
using
VBA? (e.g. every two days or the first time it opens every day)

2. When I select backup "Back Up Database..." only backs up the front end
database.
Can I create a back-up with the linked tables imported as local tables
including their relationships ?

Thank you
 
A

Allen Browne

If the database is in use at the time, the copy you make may be
inconsistent. For example, the addition of a new record or a cascading
delete in between the time you copied the main table and the related table
would mean tables without integrity.

If you want to do it anyway, this code creates a backup:
http://allenbrowne.com/Backup.txt
 
Top