Microsoft Access has encountered an error and needs to close

[Guest]

I am running an MS Access 2003 application that I developed originally in
Access 2000.

Every once in a while a get an error when I try to load a particular record
into a form. "The error is: Microsoft Access has encountered an error and
needs to close ..."

Some records load fine while others encounter the error. I have looked at
the BE data and could not find anything that looked abnormal.

Does anyone know might be causing this error?

Thanks in advance!

Dwight

 

[Dodo]

Every once in a while a get an error when I try to load a particular
record into a form. "The error is: Microsoft Access has encountered
an error and needs to close ..."

Compact and repair?

 

[Guest]

Dodo
I have tried compacting and repairing the FE and BE. To make it even more
illusive, it does not happen to every user. Every user is using the same BE
but the FE is loaded on their PC. The code and forms on the FE are the same
for each user.

Any idea?

Dwight

 

[Dodo]

Dodo
I have tried compacting and repairing the FE and BE. To make it even
more illusive, it does not happen to every user. Every user is using
the same BE but the FE is loaded on their PC. The code and forms on
the FE are the same for each user.

Any idea?

I have no experience with split databases.

Any other applications running on that specific computer when this happens?
Some programs handle memory assignments very sloppy.

Is it a complex form requiring a lot of memory or many objects open
simultaneously in the database? Could it then be a memory problem?

 

[Tony Toews]

I am running an MS Access 2003 application that I developed originally in
Access 2000.

Every once in a while a get an error when I try to load a particular record
into a form. "The error is: Microsoft Access has encountered an error and
needs to close ..."

Sounds like one or more records are corrupted.

See the Damaged records within tables section in the To retrieve your
data from a Corrupt Microsoft Access MDB page at my website
http://www.granite.ab.ca/access/corruption/corruptrecords.htm

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