If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Database Corruption
Hi,
I have developed a system with backend database Access97. Number of users that use the system is about 20. The system has been run for about 3 to 4 years. As number of users increase, the backend database sometimes corrupted and finally it is needed to be rebuilt. The frequency is about 1 to 2 times per month. Sometimes even 3 times. It's quite annoying. Can anyone tell me the reason and how to prevent the corruption of database? The following are some information of the DB 1. The size of database is about 200mb after compaction. 2. The system is written in VB 6 3. It is found that before the crash of db, users are usually calling a crystal report(report writer of VB6 with version 4.6). Thanks a lot and thanks in advance. Joan |
Thread Tools | |
Display Modes | |
|
|