Jetcomp Not Repairing Database - Just Says "Error in Compacting DB"

[scottdev]

DB became corrupt when accessed over a network - diffrent versions of Access were running. Upon trying to open a specific table, get error message "The Size of a Field is Too Long". Another table returns the error message "This Object Requires a Newer Version of the MicroSoft Jet Database Engine" (Still get this error even after upgrading to 4.0).

I upgraded to 4.0 jet engine. Installed Jetcomp and ran it per the instructions. It just returns an error message: "Error Compacting DB".

It doesn't create a new DB. Sometimes it even deletes the destinantion DB. My understanding is that certain errors will cause the destination DB to be deleted, rather than be reported in some type of error table. I'm not sure where this error table is located even if the error was a reportable error.

The DB is about 130 megs and growing. I need to compact it soon before it gets out of control. If I do have to create a new DB, can I export my queries too the new DB? I have around 100 queries. Or better yet, is there a way to copy the entire format (all tables and queries) to the new DB?

Any ideas on how to fix this?

 

[hermanlaksko]

You can try the dbengine.compactdatabase etc. or

1. If you have an Access97 database there is a way to recover which works in most cases. Open the database in Access2000 and accept the conversion option. This generally works. Then you save the database back as an Access97
database. I have had to use this method on 3 occasions and it has worked each time.

Further: Have you inspected the header of the database file using a hex editor?
I once repaired a totally inaccessible database by cut'n'paste the header from a freshly created database file to the corrupted file (well, a copy of this, of course).