Back up access db to external hard drive without replicating

[Imicola]

Hi,

I recently got an external hard drive to backup all my files. The easiest way it seems to synchronise between my desktop computer and the backup files on the external hard drive is to use Microsoft briefcase, but this then makes a replica of the database - which is not what I want.

All I want is a copy of the most recent version of the database as I develop it, but to do the sychronisation manually seems a bit time consuming as I have a lot of other files to back up.

Sorry, Im not sure if this is the correct forum to post this question in, but any help on how I can update my backup files easily and quickly without replicating databases is much appreciated!

Thanks,

Nicola

[nico5038]

It's not really an Access problem, but I guess the solution would be to find some backup application that does this on a regular basis.

Having that scheduled with the windows scheduler will make sure you have a backup every day.

Nic;o)

[NeoPa]

Actually, the COPY command in Windows would do the backup for you quite adequately. The Scheduler is still a good idea for the full automation. The easiest way to do a COPY from the Scheduler is to put the COPY command in a Command (*.Cmd) or Batch (*.Bat) file.

[Denburt]

On the Main Menu of my Apps that I create in Access I always set the open event to check the username and if its me I set a checkbox to visible. I then use this to make regular backups or even upload the frontend to the server.

If you use this approach then you may want to compact it first.

CopyFile Application.CurrentProject.FullName, rs!ServerPath & Application.CurrentProject.Name, False

[Denburt]

Rereading my previous post I relized that I left out a lot of code and what not if you are interested in this approach let me know. You stated that you had a lot of files so there is a number of ways to do this. You can store their names and location in your database and then access their location or just make a list. Here is a snippet of vbs code that I use for copying files.

Paste the following in Notepad and save as whatever.vbs using the taskscheduler will run this and allow it to run a designated times.

Dim strFile,dfol
 
strFile = "C:\\FILE TO COPY AND LOCATION"
dfol = "G:\\YOUR DESTINATION"
 
Function CopyIt( )
Dim fso
Set fso = CreateObject("Scripting.FileSystemObject")
strErr = fso.CopyFile(strFile, dfol, True)
Set fso = Nothing
End Function
 

Crude but functional. :)