We help IT Professionals succeed at work.

Automate Access MDB File BackUP's

Anita2002
Anita2002 asked
on
578 Views
Last Modified: 2008-03-04
I want to take backup of an access database file by simply copying .mdb file (DOS command) on a daily basis.

Are there any chances of getting a bad/corrupt copy if someone else is working with the file at the same time. I mean if the .ldb file is still sitting in the folder.

The file I'm trying to backup holds actual data (BackEnd), Users will be using another mdb file (FrontEnd) to link to the backend file.

Can someone help me to get over this.

Thanks!
Comment
Watch Question

AndyAinscowFreelance programmer / Consultant
CERTIFIED EXPERT

Commented:
If data is being written to the backend (or is in the middle of a transaction) then I would be very worried about the validity of your 'backup'.  That is if the copy doesn't fail - which leads one onto how do you propose to check the copy went OK?

Is your database system in use 24 hours per day?
Can't you enforce rules that your users are logged out if they don't use the system for a period of time (and then do your copy at 3 am)?

Author

Commented:
I appreciate your response!

I don't have any workgroups setup for the application and I can't enforce any rules for accessing the file. Also, I don't have any modules setup for users/groups to use the app.
--
Can't you enforce rules

It's not a round the clock database but the thing is someone might left their apps open while leaving the desk in the evening!
--
Is your database system in use 24 hours per day?

Any other way you could think of?
Freelance programmer / Consultant
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
AWESOME guyz! Thanks!

Commented:
you are welcome, glad we could help.

Steve
AndyAinscowFreelance programmer / Consultant
CERTIFIED EXPERT

Commented:
Just an aside.  If the PC crashes or the user switches it off the ldb fil could still be present even though no actual FE-BE connection is present.

Commented:
And if that is true you need to stop it from happening as that is a sure path to corruption of your mdb file.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.