How to Auto Backup MS Access 2003/VBA Program

[Guest]

Twice now I have lost an entire day's programming because I failed to create
a backup before my computer crashed.

How do you set up MS Access 2003/VBA to auto backup at specified time
intervals?

 

[aaron.kempf]

are you talking about the DATA or the application?

you need Access Data Projects; and a simple scheduled job (assuming
you're using MSDE)

i mean; if you pick up a copy of SQL Server developers' edition for
$49; it is QUITE powerful and it can automate stuff like this quite
easily

-Aaron

 

[Larry Linson]

Twice now I have lost an entire day's
programming because I failed to create
a backup before my computer crashed.

Gee, I don't believe it took that much incentive to convince me to manually
copy the database (frequently) I was working on to an archive. I pick a time
that balances between wasting effort by saving too frequently and recovering
if I crash. If I am working using Windows API, which is likely to take the
system down if I make an error, I'll save even more frequently.

When I add VBA code, I usually compile and save before testing it, because
the VBE does not prompt for saving. Again, it only took a couple of
"un-Break-able" application hangs to learn this was A Really Good Idea.

How do you set up MS Access 2003/VBA
to auto backup at specified time
intervals?

Unfortunately, that is not one of Access' features.

Larry Linson
Microsoft Access MVP

 

[Tony Toews]

Twice now I have lost an entire day's programming because I failed to create
a backup before my computer crashed.

How do you set up MS Access 2003/VBA to auto backup at specified time
intervals?

I copy and paste within Windows explorer every time I finish up a
significant piece of logic or whatever. I can have two or five copies
a day. I archive them off to CD every few weeks. As well as making
a backup every few days.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[rajesh]

hello sir,
i am working at one software company.i developed one project for
maintaining student record by use of VB and MS Access. now i need how
to take the back of records in table from MS Access.

yours lovingly
kannan.s

 

[aaron.kempf]

Tony;

what a joke; use SQL Server Express or MSDE it is a lot more practical
to have 'real' backups

what newbie network admin is going to know how to look in linked table
manager and backup a dozen different linked databases?

sql server; it is easy to backup multiple databases; on a scheduled
basis-- it is called a 'maintenance plan'

-Aaron