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.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 2

Visit Your Group

Please zip all files prior to uploading to Files section.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___