Access 2000 Compact error - Error code is -1017

Posted on 2006-03-30
Last Modified: 2008-02-01
After compacting a corrupt Access 2K DB, I now have the table MSysCompactError, which contains ErroCode -1017, and ErrorDescription, "Could not find field 'Description'".

Anyone know what this means?

Note: This DB does have linked tables, and did before compact aswell, if that makes a difference.
Question by:wbstech
    LVL 4

    Author Comment

    Additional info: The table in question, according to MSysCompactError, is called 'StudentStatus'. Neither the original or the compacted version of this table have a field by the name of 'Description'.
    LVL 54

    Accepted Solution

    LVL 4

    Author Comment

    Well, it seems to be fully functional and the corruption has gone. The error it's giving in that logfile(in the form of a Sys table), relates to the table which was originally corrupt; So I suppose it's to be expected.

    One of those links suggests it's to do with having referential integrity enforced; and a few other reasons. But, it's working, so hoorah.

    I'll try that Jetcomp next time. Looks a bit more indepth. Thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now