Heeeelp!!!

[Brian Martin]

My database keeps coming up with module not found and when I click the help button I get the following information:

Modules aren't loaded from a code reference — they must be part of the project. This error has the following cause and solution:

The requested module doesn't exist in the specified project. For example, the statement MyModule.SomeVar = 5 generates this error when MyModule isn't visible in the project MyProject.
See your host application documentation for information on including the module in the project

What can I do to save it??

 

[chrismcbride]

Things like this are sometimes solved by opening a new blank database and importing all of the objects from the old one.

Chris

 

[Brian Martin]

Any other ideas

Anyone know an easier way of fixing this. I'd rather not have to move everything to a new database.

 

[Brian Martin]

After the error notice I also get this information.

The form name 'Form1' is misspelled or refers to a form that doesn't exist.

If the invalid form name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the macro window, and eneter the correct form name.

But there is no macro. I dont need form 1 either but it wont let me delete it.

Also I tried to copy and paste my table and queries into another database but I keep geeting an error saying it can't because there are no read permissions but i have set all permessions for every table and query.

What can I do?

 

[Rich]

As a last resort, have you tried re-installing Access?

 

[Matthew Snook]

Item 1: Missing module. When does the error occur? When the database is opened; upon execution of certain commands or opening of other forms? Something must be looking for this missing module. If you can find the reference then delete it or change it.

Item 2: Read permissions. Depending upon your security arrangement you may have to take some extra steps to copy the tables and other objects into a new database. If you are using a custom security file *.mdw then the new database must also be opened with that same security file, in order to have the same permissions as the mdb you are trying to replace. After you open the new .mdb with the old .mdw, copying is easy; just 'File/GetExternalData/Import', choose the old .mdb, select all and import.

Been there. Done that.

Matt