help with corrupt database

From: Amanda C (C_at_discussions.microsoft.com)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 04:17:03 -0800

Hi Allen
I read your post below in the hope of finding help with a database that's
just died on me. I tried to compact & repair a database (Access 2002, in a
Windows XP OS) for maintenance & before completing it returned the error "AO
Index" is not an Index in this Table. Does this mean my MSysObjects Table is
stuffed?

I can't run the compact & repair utility now - I just get the same error.
Similarly, I can't create a new d/b & import all the objects because I get
the same error. I have tried running the Jetcomp.exe from Microsoft - and it
runs but before completing returns an error with compacting the database.

Do you think this file is corrupt beyond repair then? Any other suggestions?

Thanks in advance for your help.

Amanda
(also from Perth..:) but working in London!)

"Allen Browne" wrote:

> Hi David. Either of your suggestions is possible, but if you doubt that
> someone deleted the records and suspect a corruption, the first thing to do
> is to make a copy of your database (without overwriting any existing
> backups). This way you get multiple attempts at fixing it.
>
> One possiblity is that the index has corrupted, but the data is still there.
> When this happens, the records disappear when the index is used to select
> the records, but may reappear if the index is not being used:
> 1. Working in the copy, create a query into TBLStudentData.
> 2. Drag a field that is NOT the primary key into the grid, e.g. Suname.
> 3. In the sorting row under this field, choose Ascending.
> 4. View the query results. Any luck?
>
> For more information, and suggestions on rebuilding a table that has a
> corrupt index, follow the steps under the 2nd symptom in:
> Recovering from Corruption
> at:
> http://members.iinet.net.au/~allenbrowne/ser-47.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "David" <anonymous@discussions.microsoft.com> wrote in message
> news:19d601c4a652$af827cb0$a601280a@phx.gbl...
> > Hello,
> >
> > I was wondering everyone thought on a problem that just
> > occured with one of my tables.
> >
> > Yesterday I noticed that in one of my tables that all the
> > record prior to yesterday were gone. I never have seen
> > this before. I have lost records before, but that was
> > through curuption. With curupted records you would see
> > misc characters, jibberish, and here it's like the
> > records started at autonumber 680. Here is the DB design
> >
> > Thers is a TBLStudentData and TBLTestingData.
> > These to tables are linked. The TBLTestingData table is
> > intact no errors.
> >
> > In a form when a student signs in, their name and address
> > go into TBLStudentData, and the Testing data goes into
> > TBLTestingData.
> >
> > Does this sounf like curuption or does sound like some
> > deleted the records.
>
>
>

Relevant Pages

  • Re: Form Dirty not firing
    ... also forces me to do a backup and compact and repair again. ... MISSING references. ... Database Utilites... ...
    (microsoft.public.access.formscoding)
  • Re: Join Split Database
    ... Correction - I was able to compact and repair; it was when I tried to import ... Make two copies of the BE file and place in separate folders on ... Best case scenario is the users will not need to use the database ...
    (microsoft.public.access.gettingstarted)
  • Re: Invalid bookmark when entering data in a subform
    ... The compact and repair, decompile and compile, and importing into a new ... And here is a standard sequence to fix a problem database. ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.forms)
  • Re: Form Dirty not firing
    ... I no longer think that my database is corrupt. ... If the property is not set, the event procedure will not run. ... > also forces me to do a backup and compact and repair again. ...
    (microsoft.public.access.formscoding)
  • Re: Database corrupted error
    ... or link them if the database is split: ... You may find there are other forms or reports that are corrupt as well, ... But I get an "automation error" when I run the ... could try to repair and still have a corrupted copy available. ...
    (comp.databases.ms-access)