Can't delete module

#1

I have a module named 'Module1' which was created in error.
If I try to delete it I get the usual 'Do you wish to permanently
delete....' message but the module remains.
If I try to open it in design view, I get a message 'The module name
'Module1' is misspelled or refers to a module that doesn't exist'. So I
can't open or delete it.
Any ideas?

--
Bob Darlington
Brisbane

#2

Have you tried compacting the database?

If that doesn't help, create a new database and import all of the objects
from the existing one into the new one.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

"Bob Darlington" <bob (AT) notheredpcman (DOT) com.au> wrote

Quote:

I have a module named 'Module1' which was created in error.
If I try to delete it I get the usual 'Do you wish to permanently
delete....' message but the module remains.
If I try to open it in design view, I get a message 'The module name
'Module1' is misspelled or refers to a module that doesn't exist'. So I
can't open or delete it.
Any ideas?

--
Bob Darlington
Brisbane

#3

Bob Darlington wrote:

Quote:

I have a module named 'Module1' which was created in error.
If I try to delete it I get the usual 'Do you wish to permanently
delete....' message but the module remains.
If I try to open it in design view, I get a message 'The module name
'Module1' is misspelled or refers to a module that doesn't exist'. So I
can't open or delete it.

When you import everything as Doug said, be sure to
select/check each module individually. Do NOT select All
Modules and uncheck the faulty module.

--
Marsh

#4

Thanks Marsh and Doug,
I'll try that today.
By the way Marsh, what is the go with having to select all objects
individually?

--
Bob Darlington
Brisbane
"Marshall Barton" <marshbarton (AT) wowway (DOT) com> wrote

Quote:

Bob Darlington wrote:

I have a module named 'Module1' which was created in error.
If I try to delete it I get the usual 'Do you wish to permanently
delete....' message but the module remains.
If I try to open it in design view, I get a message 'The module name
'Module1' is misspelled or refers to a module that doesn't exist'. So I
can't open or delete it.

When you import everything as Doug said, be sure to
select/check each module individually. Do NOT select All
Modules and uncheck the faulty module.

--
Marsh

#5

Bob Darlington wrote:

Quote:

Thanks Marsh and Doug,
I'll try that today.
By the way Marsh, what is the go with having to select all objects
individually?

If I were guessing, it'd be so you don't select and attempt to import

the faulty module as well.

#6

Bob Darlington wrote:

Quote:

Thanks Marsh and Doug,
I'll try that today.
By the way Marsh, what is the go with having to select all objects
individually?

If you select all modules, the bad one will be selected, but
the bad one will either not be there to deselect or you will
be unable to deselect it because of the same problem that
module has when you tried the other things. Then the import
will fail on the bad module.

If you know it is a bad module, then you can use select all
on other type of objects, just not module objects. If it a
form or report or a form/report module then avoid using
select all for the form or report objects.

--
Marsh

#7

Thanks Marsh. That makes sense.

--
Bob Darlington
Brisbane
"Marshall Barton" <marshbarton (AT) wowway (DOT) com> wrote

Quote:

Bob Darlington wrote:

Thanks Marsh and Doug,
I'll try that today.
By the way Marsh, what is the go with having to select all objects
individually?

If you select all modules, the bad one will be selected, but
the bad one will either not be there to deselect or you will
be unable to deselect it because of the same problem that
module has when you tried the other things. Then the import
will fail on the bad module.

If you know it is a bad module, then you can use select all
on other type of objects, just not module objects. If it a
form or report or a form/report module then avoid using
select all for the form or report objects.

--
Marsh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Can't delete module

comp.databases.ms-access comp.databases.ms-access

Can't delete module - 06-21-2010 , 01:31 AM

Re: Can't delete module - 06-21-2010 , 05:55 AM

Re: Can't delete module - 06-21-2010 , 09:12 AM

Re: Can't delete module - 06-21-2010 , 05:30 PM

Re: Can't delete module - 06-21-2010 , 06:26 PM

Re: Can't delete module - 06-21-2010 , 09:47 PM

Re: Can't delete module - 06-21-2010 , 10:57 PM