Is it okay to run Access 2000 compact against Access 97 db?

  • Thread starter Thread starter geoff
  • Start date Start date
G

geoff

I have/had a corruption problem with an Access 97 db.
When I ran the compact utility against it, the compact
would 'fail' and entries would be placed in the
mysyscompacterrors table. When I used the compact utility
that is part of Access 2000, the compact does NOT fail,
although entries are put in the msyscompacterrors table.
Subsequent runs of Access 200 compact against the Access
97 db remove the msyscompacterrors (i.e. the 'corruption'
must have been fixed by the previous Access 2000 compact
routine).

So the question is, is it 'okay' to run Access 2000
compact routines against Access 97 mdb's (i.e. is this
supported)?
 
So the question is, is it 'okay' to run Access 2000
compact routines against Access 97 mdb's (i.e. is this
Click to expand...

Yes, you have to be sure that it compacts to A97 format,
or convert it back to A97 format after.
97 db remove the msyscompacterrors (i.e. the 'corruption'
must have been fixed by the previous Access 2000 compact
Click to expand...

Not so much fixed as deleted. Compact deletes stuff
that is wrong - including, if necessary, tables and
indexes...... some of it gets listed in msyscompacterrors,
so you can check to see if you lost anything important.
Sometimes it doesn't even get listed :)

(david)
 
Back
Top