error msg. "This action will reset the current code in break mode"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm getting the above error message when closing a query from datasheet view.
I have to go into design view in order to close it. Also, when I open a
couple of my queries, they open in SQL view. I know there's probably a
hundred reasons why this could happen, but does anything obvious pop into
anyone's head?

Thanks
 
A query may save in SQL View if you were actually in that view last time you
modified it, or if it is something that can't be shown in design view (such
as a UNION query).

The other message is a worry though. If you are not in break mode and get
the message in the subject, it does suggest your database is corrupting.
Suggested steps:

1. Compact to get rid of any junk:
Tools | Database Utilities | Compact

2. Close Access, and make a back up copy.

3. While Access is not running, decompile your database by entering
something like this at the command prompt . It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Compact again.

If that does not solve the problem, try rebuilding by following the 6 steps
in the first symptom in this article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Back
Top