Help with automate mdb backup software

Asked By Judy Plum 120 points N/A Posted on - 03/26/2013

 

Hello,

I'm working on a program using VB.net 2003 and a Jet 4.0 MDB database. I understand that sometimes these databases can get corrupted.

How often and under what circumstances can a database get corrupted?

The database I will be using is fairly basic. It contains a single table, with about 5000-6000 records, it's under 1MB in size. The program is for a stock taking application (where our stores product is scanned, the database is updated with the product count). So if the database becomes corrupted halfway through the job, I will get bad grade in my project, so please anyone know automate mdb backup software that I can use?

• Status: Open
• Question Views: 922
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Marvin M Calderon

Go To Solution

Best Answer

Best Answer

Answered By Marvin M Calderon 55 points N/A #135668

Help with automate mdb backup software

Hello Judy plum,

                 If you want to save your data from corruption then you have to save the backup of your data each time you insert new data in it. And after that you have to run the recovery of the data in case of your data get corrupted it can save your data to the previous form and you can never get you data loss there. Basically there are many reason it can get corrupted by viruses, By malware attack or crashing of your computer. But backup is the sure way to save your data.

About Marvin M Calderon

Questions
23

Answers
200

Best Answers
88

• Vote Up 0 Vote Down

• Posted on - 04/20/2013
• Question Category: MS Access

Answered By Sharon D Mickelson 10 points N/A #135669

Help with automate mdb backup software

The chances of your database getting corrupted are very less as there is not going to be huge transaction in your Database.

The possible reasons I can think of are Database growing too large in future, virus infection in your computer.

The simplest way to manage your database is to add a independent script or a logic in your code to copy the .mdb file into another location before and after modifying it. I assuming the updates are going to happen once in a while and so this solution is feasible.

About Sharon D Mickelson

Questions
13

Answers
102

Best Answers
38

• Vote Up 0 Vote Down

• Posted on - 04/20/2013
• Question Category: MS Access