What causes #Error to display in Table displays?

[Guest]

I have an Access 2000 application that contains 35 tables 80+ queries and 130
forms and reports. Everything seems to work fine except periodically 1 table
gets a record added that has the litteral #Error in each field of the 15
fields in only 1 or two records (the table contains 15000 records) and gets
added to each day. This problem does not occur every day.
What causes these records to be created without any indication and how can I
find out what is causing this problem? Users report that they either do not
see reports or cannot see forms that use this table but they don't know what
table is involved or what action might have caused the problem.
Any help will be appreciated.

 

[Rick Brandt]

I have an Access 2000 application that contains 35 tables 80+ queries
and 130 forms and reports. Everything seems to work fine except
periodically 1 table gets a record added that has the litteral #Error
in each field of the 15 fields in only 1 or two records (the table
contains 15000 records) and gets added to each day. This problem does
not occur every day.
What causes these records to be created without any indication and
how can I find out what is causing this problem? Users report that
they either do not see reports or cannot see forms that use this
table but they don't know what table is involved or what action might
have caused the problem.
Any help will be appreciated.

This is a symptom of file corruption. If you're lucky, a compact/repair will
correct it.