how to backup Current Using microsoft access 2013 database

is there some way with vba to backup Current Using microsoft access 2013 database ?

thanks a lot
bill201Asked:
Who is Participating?
 
omgangIT ManagerCommented:
If I remember correctly, the batch file had simple commands such as
copy /y c:\SomeFolder\AccessBackendDB.mdb d:\SomeOtherFolder\AccessBackendDbBKP.mdb

OM Gang
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
While you can copy the database file at anytime, there is no guarantee that your copy will be in a consistent state.   You only can get a 100% accurate backup if the database is closed.

Jim.
0
 
bill201Author Commented:
And a back end is possible?
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
omgangIT ManagerCommented:
Definitely NOT contradicting @Jim Dettman but years ago I used to run an hourly batch file to copy backend Access db files for the sole purpose of data recovery (hey!  I said years ago..).  So, Yes, you can copy a backend file even while users have frontends open with connections to it.  As Jim indicated though there's no guarantee of consistent state.
OM Gang
0
 
bill201Author Commented:
is there some way to check if the backup files is corrupt for examle to compare between the Two files
0
 
omgangIT ManagerCommented:
For a backend db we wouldn't expect the two files to be the same.  So, I guess I'm thinking the answer is No.

What, specifically, are you wanting to accomplish?
OM Gang
0
 
bill201Author Commented:
Before any Significant changes on the database I want to save on an extra location  with a time stamp.
Why is not possible to compare between the back end  And the backend backup?
0
 
omgangIT ManagerCommented:
Maybe I am misunderstanding.  I'm thinking of the backend as tables only, i.e. data.  In a production database the data changes continually so a backup from one hour ago shouldn't be expected to match the current state of the database.

If you are wanting to compare shcema that's different.  I don't know if there is a tool for that though.
OM Gang
0
 
Jeffrey CoachmanMIS LiasonCommented:
Yes, ...Lets be clear,

Are you wanting to back up the front end, Back end, or both?

Why does the database have to be "Current" active.

is there some way to check if the backup files is corrupt for example to compare between the Two files
This seems to be a separate question...?
Is the original question answered?

In any event, it is rare for a backup of a reliable production db to become corrupt, ...just by backing it up.

JeffCoachman
0
 
bill201Author Commented:
I want both backup the The frontend And the backend, of course if its not possible I want to know how can I backup at least the back end.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can't backup a file where you're running code, so you couldn't backup the FE (nor is it really necessary in a split database). As others have said, you can use the Copy commands to "backup" the BE.

I don't know of any VBA (or other) code you could run to determine if a file is corrupt. You could compare files, but as omgang said it would be somewhat pointless. The backup would be identical until someone made a change to a record, but if you Backup-Compare, it's always going to be identical.

If you want a reliable backup, then use the Windows Backup service, or a commercially available backup program.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Your other option would be to convert the BE to SQL Server, which has on-line backup capability built in.

Jim.
0
 
bill201Author Commented:
thanks a lot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.