Can't make changes- Error: You canceled previous operation..

  • Thread starter Thread starter Jim Tinder
  • Start date Start date
J

Jim Tinder

Not sure how it happened; but, after some work on my
database I can't make changes to any modules (queries,
macros etc. changes seem to be OK). After making a change
to a module I am getting an error message "You canceled
previous operation" with a message box with OK as the only
option. The message box comes up 6-7 times. If I then try
to close out the database the message comes up again
several time followed by a message box with Yes/No/Cancel
option to close the database. The only way to get out is
the No option that indicates "no save of changes".

I think I hit this same thing once before but don't
remember how I got out of the problem. I think the problem
arises when I opened a popup form (that has an associated
module) in design mode and saved it as a new form name.

I've rebooted etc., gone back in and clicked on the module
stop execution button, verified there is no "hanging" LDB
file, deleted the cloned popup form, etc. Nothing seems to
work.

Any ideas/help...
Thanks
Jim Tinder
 
Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

Then compact the database:
Tools | Database Utilities | Compact

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