Automatic backup

[kriscs]

Hi,
Is it possible to create a macro that will automatically save the whole database to a specific location, whether automatically or at the press of a button on the switchboard?
Again, this a for a project at school and I have no idea how to go about it.
thank you
Kris

 

[Rickster57]

Backup

One of several ways is to use the FileCopy command.

 

[kriscs]

Is that to be used in the visual basic editor?
I saw a command called 'copydatabasefile' in the list of macro commands. I did try to get this to work but with no success. Is this also a possible way?
Thank you

 

[sunilvedula]

Hi, you can try using the following threads example. it works for me. Any issues please let me know
http://www.access-programmers.co.uk/forums/showthread.php?t=123508&highlight=automatic+backup

http://www.access-programmers.co.uk/forums/showthread.php?t=169725

to make the codes above work you need to go to tools-> reference and check the microsoft scripting runtime in editor