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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.