Help with corrupted database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • daD
    #1

    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!!
    Tags: None
    • Tom van Stiphout
      #2
      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]

        Comment

        • David W. Fenton
          #3
          Re: Help with corrupted database

          daD <JAMESFREY3@COX .NET> wrote in
          news:jjje92tb7t uujk2l8jnp0aer0 0c007fb8p@4ax.c om:
          [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/

            Comment

            Previous template Next
            Working...