Invalid Argument and #Error in Table

[Stephen]

I have a table that is the "Many" in a one to many
relationship for 2 other tables. The last record of the
table has "#Error" as the entry for each field. A pop-up
window appears and says "Invalid Argument" whenever the
table is opened. Access won't allow me to delete this
record nor the records joined to this one, even if I
change the relationships to "Cascade Delete." I've tried
compacting and repairing the databse. Any ideas?

 

[Tony Toews]

I have a table that is the "Many" in a one to many
relationship for 2 other tables. The last record of the
table has "#Error" as the entry for each field. A pop-up
window appears and says "Invalid Argument" whenever the
table is opened. Access won't allow me to delete this
record nor the records joined to this one, even if I
change the relationships to "Cascade Delete." I've tried
compacting and repairing the databse. Any ideas?

See the Damaged records within tables section in the To retrieve your
data from a Corrupt Microsoft Access MDB page 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