"This action will reset the current code in break mode" message when CLOSING a TABLE

Posted on 2004-11-29
Last Modified: 2012-08-13
I am running Access 2K on a WinXP machine.

When I open a TABLE and look at the data I get the message:

This action will reset the current code in break mode.  

When I try to X out of the table.  The only way to kill the error message is to use the task manager to close access.
Keep in mind, no user created code should be running.

I am able to copy the table STRUCTURE, but not the STRUCTURE and DATA.  When I attempt to copy STRUCTURE and DATA, no records are copied.
If I create a new mdb file, then attempt to import the table, the table is imported, but NO records.  When I open the empty table, then try to close it, the same problem shows up.

If I try to append all records created before RecordCreateDate <#11/23/04# everything appends correctly.
If I try to append all records created before RecordCreateDate <#11/24/04# the operation fails.

It seems to me as though there is a corrupt record somewhere that is causing some internal code to fail.

Please help!!!
Question by:pcalabria
    LVL 4

    Accepted Solution

    It definitely sounds like you have a corrupted record. I'm assuming you've tried the basic compact and repair, and as indicated, you've tried importing into a new DB, without success. My suggestion would be to attemt to find the corrupt record, delete it, and then reimport everything.

    There will usually be some indication in the data the it's a bad record. First thing to do would be to sort the table and see if anything seems out of sorts. Sort on the Primary Key, and some of the other commonly used fields.

    Another method to locate, use some make table queries to split the table into halves, and try importing the result table of those queries. Use the Primary Key to split things up. Assuming that one of the tables will not import, repeat until you can locate the bad record. Binary searches aren't fun, but they usually work.

    I've had to do that a few times, and it's not fun.

    Hope that helps.
    LVL 26

    Expert Comment

    by:Alan Warren
    Try creating a new blank database and import the table into the new database, if succesfull, rename your old table in the original database and import the table from the new database you created. Sounds like corrupt tabledef entry.


    Author Comment

    MGPSoft1, I used your make table query idea to find the bad record.  Once found, I deleted the record, which fixed the problem.

    All fields of the bad record looked normal ...except one.
    In one field, instead of finding data, I found: #Deleted

    Half of my problem is solved.... I have now found the bad record and deleted it to correct the situation...

    Now for the other half... How the heck did this happen in the first place????  What caused the: #Deleted  entry to show up in the first place?

    Is it possible that a special key combination was entered with the record open?  I remember in dBase III a similar problem could show up if you marked a record for deletion but did not PACK the database.  Is this a similar problem?  

    Alan, thanks for your suggestion.  Actually, I had tried importing and no records were imported.
    LVL 44

    Expert Comment

    the field that showed #Deleted was probably a LINKED field to a record in another table, and the corresponding record in that second table had been deleted.  This is known as a ORPHAN record, and probably indicates that you should set up a RELATIONSHIP between the main table and this second table, and in that relationship you should enforce REFERENTIAL INTEGRITY.

    LVL 4

    Expert Comment

    I'm not quite 100% sure what causes these errors, but my best guess is that Memo fields are part of the problem. I have a really big table in one database, and it has a few memo fields in it. Why I do it that way is another reason. But I've seen hints in newsgroups and such that if 2 people edit a memo field at the same time, it causes corruption. Again, that's my best guess at it, not quite sure.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now