Database corrupt??

[Guest]

Since yesterday I've started getting "module not found" and "you cancelled
the previous action" error messages.

Is it corrupted?

I've copied the DB. If so, what do I do?

thanks

 

[BruceM]

Rather than copying the database, create a new blank database. Turn off
Name AutoCorrect. Click File > Get External Date > Import. Navigate to the
old database, and select the objects you want to have in the new one. Click
the Options tab if you have custom toolbars and menus. You can select the
tables, click the Queries tab and select the queries, and so forth through
the tabs until you have selected everything you want in the new database,
then import them all in one shot.
I don't know if this will address the issue, but it is worth knowing about.

 

[Guest]

Thanks for that. It has compacted the DB quite well.

It has partly worked but I am still getting the "you cancelled the previous
action" error message. It is happening when I click on a button. The odd
thing is that I don't get the message for all the buttons.

 

[Guest]

In that case it's either the code for some event on that button is doings
something wrong or the form is corrupt. It's slightly possible that the
database is corrupt to. If you have an old copy of that form when it use to
work, import it in.

For more information on corruption check out the following:
Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Arvin Meyer [MVP]]

Since yesterday I've started getting "module not found" and "you cancelled
the previous action" error messages.

Is it corrupted?

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Guest]

Hello Arvin

Thanks for all the links but It seems to be okay now. It didn't seem too
serious. I have made a copy though.

 

[Rob Parker]

You can get Error 2001: "You cancelled the previous operation" if you have
an aggregate function with an invalid Where clause. I had exactly this
problem a couple of days ago - I had a statement:

i = Nz(DCount("*", "qryInvalidTimes", "CourseLevel = 'PGElec'"), 0)

and had changed qryInvalidTimes so that it no longer contained a CourseLevel
field. Exactly that error!

HTH,

Rob