Database Corruption Problem

[Echoison]

Here is my problem in a nutshell: Have a program with an Access 2000 backend Database that is stored on a Novell 5.1 Server. There are 3 users connecting and using the data over Novell's 4.83 SP2 Client.

The database becomes corrupt occasionally and we have not been able to pin point a cause. Any Ideas, anyone else have a similar problem of database corruption over a Novell network? Please help.

Thanks.

 

[WayneRyan]

Echoisn,

Access is not very forgiving if you have network troubles. Are
your users complaining about being "kicked off" or losing their
connection. If that is the case, all you can do is clean up the
network and back up often, so that when/if it becomes
corrupt again, you have a very recent backup to fall back on.

Wayne

 

[bob bisquick]

Preventing Database Corruption

I have been having lots of problems with this. After research and trial and error I have several suggestions.

1. Run a compact and repair daily - I don't know anything about Novell Servers, but on a Windows Server I would install the database on the server. In the Task Scheduler, set it to compact and repair the database every night (not at the same time as back up). In the advanced properties, there is a comman line (Run) Put this there:

"C:\Program Files\Microsoft Office\ART\Office\msaccess.exe" /wrkgrp "PATHOFSYSTEMFILE\SYSTEM.MDW" /repair "PATHOFDATAFILE\H_S_data.mdb" /compact

If there is an internal password on your database, you can add:

/user username /pwd password

For this to work, all users of the database must log out at the end of each day.

2. Make sure every computer has the latest version of the microsoft jet engine - go to microsoft updates

3. Make sure every computer accessing the database is using the same operating system with the same service packs.