Creating a backup copy

[Guest]

I have created a project costing database. I want to give
users the ability to make backups of the mdb file via
a "utility" form within the database. When the user
chooses to create a backup, I would like a new mdb file be
created, that includes a timestamp in the name, and
includes all the database objects from the original
database
Any ideas

 

[Wayne Morgan]

Access 2003 has this.

 

[Guest]

I'm using Office XP. Is there a similar function or recommended programming approach?

 

[Wayne Morgan]

It's a new function in Access 2003. If the file is opened in shared mode,
you can probably get by with just copying the file using the VBA FileCopy
command. The only problem would be if you tried to copy at the same instant
someone was making a change to the file. If this happened the copy would
probably be unreliable.

The following links may give some better ideas.
http://www.mvps.org/access/api/api0026.htm
http://www.mvps.org/access/modules/mdl0045.htm

Also, some backup programs have what is called an "Open File Option" to
allow them to backup open files. I've heard mixed reports on how well these
work.

--
Wayne Morgan
Microsoft Access MVP

I'm using Office XP. Is there a similar function or recommended

programming approach?

 

[Guest]

Thank you. Worked perfectly.