autobackup

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

Hi all,

I am using .transferdatabase

to export a table each hour while a table is in use to make a backup

Is it ok? or is it unsafe?

If i go in the table and edit a record, leave the table open while in a
field changing something and activate the transferdatabase
the table is exported correctly with the data
prior to the edition in the concerned record.

What are people doing to make autobackup in access?

best regards
pierre
 
The right thing to do is to seperate between the data and the application.
in one MDB you have all the tables, and in the other one you have all the
other object + link table to Data MDB.
What you get out of it?
1. you back up all the data by copying the mdb to another place, you back up
all the tables in one go.
2. when you have a new version, you can give the user a new version without
worrying of deleting the data.
3. If the application you run crash it wont hert your data.
4. You can have multi users.

and more.
so if you already have this setup, then just copy the all mdb to another
place.
 
Back
Top