By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,057 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Back up access db to external hard drive without replicating

P: 9

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!


Mar 15 '07 #1
Share this Question
Share on Google+
4 Replies

Expert 2.5K+
P: 3,072
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.

Mar 17 '07 #2

Expert Mod 15k+
P: 31,494
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.
Mar 20 '07 #3

Expert 100+
P: 1,356
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
Mar 20 '07 #4

Expert 100+
P: 1,356
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.

Expand|Select|Wrap|Line Numbers
  1. Dim strFile,dfol
  3. strFile = "C:\\FILE TO COPY AND LOCATION"
  4. dfol = "G:\\YOUR DESTINATION"
  6. Function CopyIt( )
  7. Dim fso
  8. Set fso = CreateObject("Scripting.FileSystemObject")
  9. strErr = fso.CopyFile(strFile, dfol, True)
  10. Set fso = Nothing
  11. End Function
Crude but functional. :)
Mar 20 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.