What causes #Error to display in Table displays?

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13215-what-causes-error-display-table-displays.html
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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13215
Any help will be appreciated.

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

HarryJ wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13215
> I have an Access 2000 application that contains 35 tables 80+ queries
> and 130 forms and reports. Everything seems to work fine except
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13215
> 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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com