Hal
Thanks for your help. I may have to go that route of using a batch file. All I need is the backup of the backend only for the client. As for the frontend I have copies on my laptop and external hard drive.
Once again thanks for the pointer.
Regards
Liveson
From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Hal McGee
Sent: Thursday, 30 August, 2012 2:17 PM
To: AccessDevelopers@yahoogroups.com
Subject: RE: [AccessDevelopers] DATABASE BACKUP
Normally I just use a batch file in Task Scheduler to make backup copies of my Access DB’s. Other wise you’ll need to create a different back-end and use delete and append queries to move the data around. This won’t help you with queries reports etc but I asuum you have those in the front end and you make copies of that as well.
From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Liveson Tumbulu
Sent: Thursday, August 30, 2012 2:11 AM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] DATABASE BACKUP
Importance: High
Hi Folks
I’ve developed quite a number of Access applications but one thing that I’ve always failed to do is Backup. I need to automate the backup process within the applications. I’ve tried to use CopyFile in VBA but it hasn’t worked. It doesn’t throw up any error but no file is copied. I guess it’s because the file, in this case the backend, is already open.
How can I copy the backend to another folder from within the application that the backend is linked to?
Thanks in advance
Liveson
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar