Back-Up Questions

  • Thread starter Thread starter kraasty
  • Start date Start date
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
 
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
 
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

looking for a way to unlock a back end mdb file 16
When Multi-User dbs Slows Down 12
Update Tables from Back End to Front end at detection 5
Front End and Back End Database Question 3
Front End seems to loose track of Data when Compacting 3
Access DB crash on form 7
Update back-end tables, fields, relationships etc... 6
How to link a split _be? 1

Back
Top