making a backup copy of a table

[Steve]

ive been too busy trying to get my database and forms to work to really
concern myself with backing things up or protecting the data in case a user
really botches something up. is there anything like archive logging for an
access database.

for now is there a way I can say copy main-table into main-table-timestamp
automatically when the application opens or say when a form is loaded?

the database is usable at this time but there are alot of tweaking I need to
do, things like locking things down so that someone needs to click on a
button to be allowed to edit something. never built it in since I was the
dev and wasnt working with real data but people need this thing to go into
action asap so am importing the actual data. as it is, its real easy for
someone to have a record highlighted in a form and all they need to do is
accidentally hit a button and the field has changed.

[Larry Linson]

The MakeTable Query is a good way to copy an entire table, but copying
entire tables may not be the best approach. How about copying the entire
database? If you do decide to make time/date-stamped copies of tables, it'd
be a good idea to make them into a separate database, just in case. If your
database becomes badly corrupted, you may not be able to retrieve anything
from it.

Larry Linson
Microsoft Access MVP
"Steve" <[e-mail]> wrote in message
news:j_*****************@newsread3.news.atl.earthl ink.net...

ive been too busy trying to get my database and forms to work to really
concern myself with backing things up or protecting the data in case a user really botches something up. is there anything like archive logging for an
access database.

for now is there a way I can say copy main-table into main-table-timestamp
automatically when the application opens or say when a form is loaded?

the database is usable at this time but there are alot of tweaking I need to do, things like locking things down so that someone needs to click on a
button to be allowed to edit something. never built it in since I was the
dev and wasnt working with real data but people need this thing to go into
action asap so am importing the actual data. as it is, its real easy for
someone to have a record highlighted in a form and all they need to do is
accidentally hit a button and the field has changed.