Urgent Help! Can't access my Access database.

[Duncan Edment]

Folks,

I'm in trouble.

It's the month end as far as our accountants are
concerned, and I need to run figures off from our database.

However, when I load it and click on a button on the main
switchboard, I get the following error message:

Run-time Error 2001: You cancelled the previous operation.

If I select Debug, it takes me to the on-click code for
the button on the Switchboard, and the
DoCmd.OpenForm "frmMonthlyFigs" line is highlighted.
Attempting to trace from here, gives me the same error as
above:

Run-time Error 2001: You cancelled the previous operation.

Selecting End, stops everything--as you would expect.

If I close the database and re-open it, clicking on a
button on the switchboard again, gives me the same error:

Run-time Error 2001: You cancelled the previous operation.

Clicking on End a couple of times, eventually displays a
message as follows:

Microsoft Visual Basic

Module Not Found

Help tells me that this has something to do with the
requested module not existing in the specified project.
However, I cannot see any lines of code that reference a
module that does not appear in the Modules list of my
database.


Net result is, I can't do a thing. The database is
secured via Access Security, so I doubt very much if any
of the users could have got in and altered code etc.--plus
I doubt very much if they would know what to look for / do.

I haven't removed any code or changed anything in the
database, so has anyone any idea what's wrong?

Help!!!

Thanks & regards

Duncan

 

[Jim/Chris]

The first thing I would do is to compact/repair the
database. This is located in Toll/Database utilities

Jim

 

[Duncan Edment]

Jim,

I tried that before and it made no difference.

I've tried it again, and still no joy.

Any other ideas?

Duncan

 

[Jim/Chris]

I got this from Joan Wild (MVP)

I suggest you copy the database first.

Try compacting your database using Jetcomp, available at
http://support.microsoft.com/?id=273956

If that fails, try creating a new database and importing
objects from the
old.

If that fails, you can try www.pksolutions.com

Jim

 

[Van T. Dinh]

The Switchboard sounds OK. The problem is in the Form "frmMonthlyFigs".
Unfortunately, there are a number of different causes for error 2001.

Open the Form from the Database Containers window, i.e. not through the
Switchboard and see if you get the same error. If you do, press Ctrl +
Break and see which line of code is highlighted. If you use error trapping
and the statement in the error-trapping code is highlighted, use Resume to
get back to the line of code that actually gave the error.

If there is no code statement highlighted, check the RecordSource of the
Form.

Do you have a back-up copy of the database? If you do, temporarily rename
the "frmMonthlyFigs" and import the same Form from the back-up and see if
the same error occurs.

 

[Tony Toews]

Clicking on End a couple of times, eventually displays a
message as follows:

Microsoft Visual Basic

Module Not Found

Try Decompiling. Make a backup first!
http://www.granite.ab.ca/access/decompile.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Duncan Edment]

Guys,

Sorry it's taken so long to respond.

I tried Jetcomp, and it was no good. Even it fell over with a problem.

I read Van's post, suggesting that the form had become corrupt. I tried to
rename it, to no avail. I tried to delete it, again to no avail.

I had to resort to using an earlier blank copy of the database. Once I had
established it worked OK, with all forms loading, I simply imported the data
from the original and now it works fine.

One question though. What could have caused the form to become corrupt?
There is nothing special about it...it simply holds about half a dozen txt
controls with associated labels. Nothing fancy or complicated.

Rgds

Duncan

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

 

[Van T. Dinh]

Generally, Access should be able to handle the Form if Access allows you to
design it. Unfortunately, corruptions can happen for no particular reasons.

It sounds like you are using 1 database file for the application. Perhaps,
you should split the application to Front-End and Back-End.

 

[Jim Carlock]

Not sure if this will help at all... but create another .mdb,
create links to the problematic .mdb. And see which things
work and which don't. You might be able to recover some
things.

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


message Folks,

I'm in trouble.

It's the month end as far as our accountants are
concerned, and I need to run figures off from our database.

However, when I load it and click on a button on the main
switchboard, I get the following error message:

Run-time Error 2001: You cancelled the previous operation.

If I select Debug, it takes me to the on-click code for
the button on the Switchboard, and the
DoCmd.OpenForm "frmMonthlyFigs" line is highlighted.
Attempting to trace from here, gives me the same error as
above:

Run-time Error 2001: You cancelled the previous operation.

Selecting End, stops everything--as you would expect.

If I close the database and re-open it, clicking on a
button on the switchboard again, gives me the same error:

Run-time Error 2001: You cancelled the previous operation.

Clicking on End a couple of times, eventually displays a
message as follows:

Microsoft Visual Basic

Module Not Found

Help tells me that this has something to do with the
requested module not existing in the specified project.
However, I cannot see any lines of code that reference a
module that does not appear in the Modules list of my
database.


Net result is, I can't do a thing. The database is
secured via Access Security, so I doubt very much if any
of the users could have got in and altered code etc.--plus
I doubt very much if they would know what to look for / do.

I haven't removed any code or changed anything in the
database, so has anyone any idea what's wrong?

Help!!!

Thanks & regards

Duncan