"You cancelled the previous operation"

[M Skabialka]

I made several changes to a copy of a database, then ran a repair and
compact. Immediately it started saying some of my forms or modules were
missing, and

"You cancelled the previous operation" many times. I tried to decompile but
get the same errors. Usually I make a copy before I compact, which lets me
know which items were changed but I didn' this time. Fortunately the users
can continue to use the older version. Meanwhile what has happed to cause
these errors on my development copy?

Thanks,
Mich

 

[Allen Browne]

Sounds like a corruption.

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"

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

 

[M Skabialka]

Well, it took a few steps, but I have recovered my database - thanks. Stil
not sure what went wrong, but I'll never compact again without making copy
first!

Thanks,
Mich

 

[Guest]

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"

This one should go into the FAQ (I looked, I couldn't google it usefully).

My left arm for accurate error messages!

Maury