Macro to Save database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a button that I want to be able to click and when clicked the "Save As" function is ran to save the whole database file in another location

Is this possible

Many Thank

Jim
 
Try this

1.Create a separate database (mdb) named Backup.md
2.Create a .bat file that copies your current database to wherever you need it to go.Name it Backup.ba
3.In your current database create a macro that runs the following
a)RunApp Command to open Backup.md
b)Quit Command to close your current database
4.In Backup.mdb create a macro that runs
a)RunApp Command to open Backup.ba
b)Quit Command to close Backup.ba
5.Create your command button on the form you wish
6.To prevent the databases to become too large,set the Compact on CLose option on your database

If you need assistance to do any of the above,please reply and I'll be glad to help

----- Jim Morrison wrote: ----

I have a button that I want to be able to click and when clicked the "Save As" function is ran to save the whole database file in another location

Is this possible

Many Thank

Jim
 
Back
Top