Help with corrupted database

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!!

re: Help with corrupted database

On Mon, 19 Jun 2006 22:06:18 -0400, daD <JAMESFREY3@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.
[color=blue]
>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!![/color]

re: Help with corrupted database

daD <JAMESFREY3@COX.NET> wrote in
news:jjje92tb7tuujk2l8jnp0aer00c007fb8p@4ax.com:
[color=blue]
> 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?[/color]

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/