Kamis, 30 Agustus 2012

RE: [AccessDevelopers] DATABASE BACKUP

 

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.

__._,_.___
Recent Activity:

Please zip all files prior to uploading to Files section.
.

__,_._,___

Tidak ada komentar:

Posting Komentar