Sure sounds like corruption to me.
Standard things to try are:
Step 0: make a backup - anything you try at this stage may make it
worse, not better.
Step 1: compact and repair
Step 2: create a new database and import everything into it.
Step 3: post back if neither of these has been effective.
HTH
- Turtle
"Serious_Practitioner" <Se************************@att.net> wrote in message
news:es********************@bgtnsc05-news.ops.worldnet.att.net...
Hello all, and thank you for your help in the recent past.
Got a new error message in the last few days.
While working with different sized tables, in datasheet view, I've gotten
this message -
"THIS ACTION WILL RESET THE CURRENT CODE IN BREAK MODE."
There's a "Yes/No" message box. The choices are -
"To halt the execution of the program so the Module window can be closed,
select 'Yes'."
"To leave the code in the current state, select No".
I get the message when I try to close the datasheet view, either to go to
the Design View or to close it altogether. Pressing "Yes" does nothing.
The message box stays open and won't close. Pressing "No" gets rid of the
message box, but trying again to close the table brings the message box
back.
The only way to close the table is with Ctrl-Alt-Delete, and then closing
MSACCESS.EXE. Reopening the database and the same table reproduces the
error.
Some of the tables in question are large (6000 records, 18 fields), some
are small (300 records, 6 fields). I don't have any other forms open, so I
don't know what code is being described.
Any thoughts out there? TIA
Steve E.