Access will report error and shutdown when attempting to view a re

[Rocks]

Cannot view a record in database. receive faulting application msaccess.exe,
faulting module vbe6.dll in application event viewer. Source: Microsoft
Office 11, Event ID: 1000. PC is Windows XP SP2 with Office 2003 and latest
service packs.

 

[Ofer Cohen]

A reply given by Allen Browne in a previous post on the same metter

----------------------------------------------------------------------
Do you have any VBA add-ins? Try removing them.

In the code window, choose Tools | Options | General, and uncheck Compile on
Demand.

Tried a decompile?

Are you the only person accessing this database? Multiple developers
modifying objects in one mdb will probably corrupt it.

Do you have at least SP2 for OfficeXP and SP8 for JET 4?
Both in the downloads section at http://support.microsoft.com

Do you have Name AutoCorrect turned off? It causes many problems, including
crashes. Details in:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

Autocompact and compact on close may contribute to the problem.

Other suggestions:
Preventing Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-25.html

 

[Tony Toews [MVP]]

Cannot view a record in database.

Is this one particular record? Using a form or table or query view?
If a form is this all records or just one record.

I ask because this could be a corrupt form or a corrupt record.

See the Corrupt Records in a 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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/