Database Corruption

[Joan]

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

 

[Eric Butts [MSFT]]

Hi Joan,

Take a look at the article: HOW TO: Keep a Jet 4.0 Database in Top Working
Condition
http://support.microsoft.com/default.aspx?scid=kb;en-us;300216

It talks about Access 2000 but also applies to Access 97.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Content-Class: urn:content-classes:message
| From: "Joan" <[email protected]>
| Sender: "Joan" <[email protected]>
| Subject: Database Corruption
| Date: Tue, 25 May 2004 20:07:16 -0700
| Lines: 26
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcRCzoyZioGF5TjpTZOTCroUooch6A==
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:79907
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| 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
|
|
|