Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Sydney, New South Wales, Australia
    Thanked 0 Times in 0 Posts

    Compact error (2000)

    We have a large database of over a million records. Due to a server problem the database was not closed probably on numerous occasions during write procedures. We deceided to compact and repair it. That finished OK but we had a new table labelled MsysCompactError. In this there were 2 entries with a 1605 erorr saying 'Could not find field 'Description'. The affected table does not have a field called description. Also we noticed the table had the primary key and 2 indexes removed. Consequently we went back to the copy we made before compacting as we don't know what other problems may have occured. I have tried to find this type of error in the knowledge base but with no luck. Can any one offer any ideas as to why this occured.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Compact error (2000)

    'Description' probably refers to one of the internal properties of the table. Apparently, one or more fields in the table had become corrupt; indexes on these fields probably also became corrupt.

    You can download a stand-alone compact utility from <!mskb=273956>Microsoft Knowledge Base Article 273956<!/mskb>. The download comes with a Word document that gives some background about compact errors.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts