Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Who Can Help Me With JetComp? (A2k (9.0.3821) SR-1 Jet 4.0)

    Who Can Help Me With JetComp?
    A2k (9.0.3821) SR-1 Jet 4.0

    I ran Jetcomp via a batch file on a database that had a corrupted record (#Deleted in all fields) in tblContractor table.

    START /WAIT jetcomp.exe -src:BadDb.mdb -dest:GoodDb.mdb

    The JetComp.Doc says:

    <In addition to the Jet database engine creating the MSysCompactError table, the Jet database engine will return an error message at the completion of compact to signify that a problem was encountered. >

    1. Why did I not get any indication of an error?

    It did put one record in the MsysCompactError table, how do I interpret this record?

    1. What should be done with the following message in MsysCompactError ?

    2. What does the -1017 Error Code mean

    3. What does Could not find field
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Who Can Help Me With JetComp? (A2k (9.0.3821) SR-1 Jet 4.0)

    When you run the internal Compact and Repair command (in Tools/Database Utilities), you'll get an error message if the compact process encountered problems. The JetComp utility is meant to run as a standalone utility, so it doesn't show this message. The error code and description , however, are available in the MSysCompactError table.
    It's hard to interpret the data in this table; the ErrorRecID field is a bookmark that can be used to find the problem record. JetComp.doc contains some sample code at the end that you can use to view the records that were modified by the compact process. (This code will only work if you haven't modified other data after running the compact.)

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Who Can Help Me With JetComp? (A2k (9.0.3821) SR-1 Jet 4.0)

    Hi Hans

    You said:

    <When you run the internal Compact and Repair command (in Tools/Database Utilities), you'll get an error message if the compact process encountered problems. >

    When I ran this as suggested, received no error message, any clues?

    It did make an entry in the MSysCompactError table.

    And it replaced field contents of corrupted record from #Deleted to ###### in tblContractor

    I ran the Sub Main() and it went to done message and I noticed no additional tables to describe the error

    What is Sub Main() supposed to do?

    John

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Who Can Help Me With JetComp? (A2k (9.0.3821) SR-1 Jet 4.0)

    John,

    I don't have a corrupted database to test it on right now <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.

    According to JetComp.doc, the Main procedure creates a new table with the same structure as the repaired corrupt table, and copies those records into it that were modified by the compact process (illegal values replaced by a string of 16 #'s). The name of the new table should be MSysCompactError with the name of the repaired table appended, in your case MSysCompactErrortblContractor.

    But if data have been edited, added or deleted in the repaired table after running compact and repair, the bookmarks pointing to modified records are not valid any more. And each time you run a compact and repair, *all* existing tables whose name begins with MSysCompactError are removed before compacting.

Posting Permissions

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