Save Database to two locations

[lhnaz]

I need to save my database to an additional location whenever it is closed - on a different server, for backup purposes.

I have a macro that closes all open objects and then exits Access and saves to the default location. How can I make the macro do an additional step - save a copy to a different location - before exiting?

I'm using Access 2007 in Windows XP.

Thanks,
Lynda

 

[boblarson]

When you say for backup purposes, doesn't your server get backed up nightly? Saving a copy of the database whenever it is closed is going to make your network folks a bit peeved as that will quickly suck up the file space and since it is an Access database it will give them more ammunition if they do not like Access databases because of their proliferation.

So, what is the purpose of doing it each time it is closed?

 

[lhnaz]

You're right Bob. It does backup nightly but the IT guys sometimes screw up (like last week) and then my database is restored with an old version. I want to safeguard against that by keeping a copy on my own piece of the server, just in case.

 

[boblarson]

Well, the best way is going to be creating a batch file which does the copy and after everyone is out of the database. But if you do it on the close of the database and it gets closed multiple times throughout the day then if you had it run on close it would, like I said, potentially create a nightmare of files.

The simple batch file can have one line (put it into Notepad):

Copy \\ServerName\ShareName\FolderName\FileName.accdb \\ServerName\ShareName\OtherFolderName\FileName.accdb

Then save it as copydb.bat or something which works for you. Then you can run it or set up a Windows Scheduler Event to run it at a certain time.

 

[lhnaz]

Thanks for the reply, Bob. I have total control of the database and I just want to over-write the file whenever I close it at the end of the day so the issue of file proliferation won't be a problem. Have a great day! ; )

 

[boblarson]

So are you good or are we still not quite there yet?

 

[lhnaz]

I'm good. Thanks for your help.