97 to 2003 - conversion errors table

[mscertified]

Converting an Access 97 db to 2003, I got a message "conversion errors
encountered - look in conversion errors table".
In the table is a single row--
Object Type: Table
Object Name: MSysObjects
Error Description: -1611: Could not find field 'Description'.

This database contains only tables, queries and reports.
Any idea what this means? All I can suppose is that some query or report
refers to a column called Description in a table that does not contain it.
But how to find out which one?

David

 

[Allen Browne]

This message probably represents a corruption in the original Access 97
database.

Try compacting the database in Access 97. It might generate the same error,
or it might remove the problem.

The MSysObjects table is not supposed to have a field named Description. It
does not store field names, so the error message should not be relating to
the contents of any of the fields. It is possible that the table has a
property named Description, but that's unlikely unless someone has been
programmatically setting table properties.

Another way to approach the conversion would be to create a new (blank)
database in Access 2003, and import everything:
File | Get External | Import

 

[david epsom dot com dot au]

It's a general error, indicating some obscure kind
of corruption. You sometimes see it when compacting
a database. Probably an error in the VBA blob, while
the VBA blob is being compacted.

I've never seen any suggestion on how to make that error
go away, other than creating a new database, but sometimes
it comes and goes by itself.

Which is worrying.

(david)