MSysCompactError

[Kit Truong]

After compacting my database, I have the following in MSysCompactErro r

ErrorCode, ErrorDescriptio n, ErrorRecid, ErrorTable
-1605,Could not find field 'Description'., ,tblFundClient
-1017,Could not find field 'Description'., ?O,UNDERITE
-1613,You cannot add or change a record becuase a related record is required
in table 'CLIENT'., , UNDERITE

Can anyone help me make sense of this?

There is no field named 'Description' in either tblFundClient or UNDERITE.

I guess the next thing I'll try is remove any unrelated records in UNDERITE
that corrospond to CLIENT. Can anyone help me with this too.

CLIENT is the main table. I want to remove any records in UNDERITE that is
not in CLIENT. How would I go abouts making this delete query.

Thanks.

[Tony Toews]

Re: MSysCompactErro r

"Kit Truong" <kit@e-nablesolutions. ca> wrote:
[color=blue]
>After compacting my database, I have the following in MSysCompactErro r
>
>ErrorCode, ErrorDescriptio n, ErrorRecid, ErrorTable
>-1605,Could not find field 'Description'., ,tblFundClient
>-1017,Could not find field 'Description'., ?O,UNDERITE
>-1613,You cannot add or change a record becuase a related record is required
>in table 'CLIENT'., , UNDERITE
>
>Can anyone help me make sense of this?
>
>There is no field named 'Description' in either tblFundClient or UNDERITE.[/color]

Sign of corruption but may be due to a self join. See the Access Corruption FAQ at
my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm