MattS
Crabby Cancerian.....
- Local time
- Today, 08:37
- Joined
- Jun 18, 2003
- Messages
- 130
I have a database which when compacted produced the MSysCompactError table. This is supposed to hold the table and record id of the records causing the error, but all it held was the table name - MSysObjects.
I spent some time going through the table, and eventually found the error. There is a field called LVProp, and for most of the items in the table this is set to 'original binary data'. However, for one of the queries this was set to 'OLE Object'.
Taking this to be incorrect, I deleted the query, recreated it, and sure enough in the MSysObjects table it now says 'original binary data'. The db now compacts no problem.
The thing is, although the problem is solved, I don't really understand why!!
If anbody could shed some light on what this field does/means, or how this error could have occurred, it would be appreciated.
Thanks,
Matt.
I spent some time going through the table, and eventually found the error. There is a field called LVProp, and for most of the items in the table this is set to 'original binary data'. However, for one of the queries this was set to 'OLE Object'.
Taking this to be incorrect, I deleted the query, recreated it, and sure enough in the MSysObjects table it now says 'original binary data'. The db now compacts no problem.
The thing is, although the problem is solved, I don't really understand why!!
If anbody could shed some light on what this field does/means, or how this error could have occurred, it would be appreciated.
Thanks,
Matt.
