Help with corrupted database

[daD]

I administer a multi-user MS Access database over a network.
Frequently, I get corrupted data that crashes the database. The most
common is "#####" in all the columns for a record. The only utility I
have is MS Jetcomp and sometimes it does not do the job. Does anyone
else have any other utilities for repairing and recovering databases?
Thanks!!

[Tom van Stiphout]

On Mon, 19 Jun 2006 22:06:18 -0400, daD <JA********@COX.NET> wrote:

If you don't want to fix the underlying causes
(http://www.granite.ab.ca/access/corruptmdbs.htm), then your best bet
is to upsize to SQL Server, which is MUCH harder to corrupt. There is
a free "light" version available on microsoft.com.

-Tom.

I administer a multi-user MS Access database over a network.
Frequently, I get corrupted data that crashes the database. The most
common is "#####" in all the columns for a record. The only utility I
have is MS Jetcomp and sometimes it does not do the job. Does anyone
else have any other utilities for repairing and recovering databases?
Thanks!!

[David W. Fenton]

daD <JA********@COX.NET> wrote in
news:jj********************************@4ax.com:

I administer a multi-user MS Access database over a network.
Frequently, I get corrupted data that crashes the database. The
most common is "#####" in all the columns for a record. The only
utility I have is MS Jetcomp and sometimes it does not do the job.
Does anyone else have any other utilities for repairing and
recovering databases?

Fix the network and the workstations. Make sure they all have the
latest service pack of Access and the latest Jet service pack. Until
you do that, you're pretty much guaranteed to experience corruption.

But corruption is *not* a normal state for shared Access databases.

The best article on this is Tony Toews page on corruption, at his
website, http://www.granite.ab.ca/ . I can't give you the correct
link as it appears to be down at the moment, but you can navigate
there from the main page when it is back up.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/