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?
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.
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.
