dbTalk Databases Forums  

Cannot delete forms and modules

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


Discuss Cannot delete forms and modules in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bob Darlington
 
Posts: n/a

Default Cannot delete forms and modules - 01-03-2005 , 07:13 PM






Using Access 2002.
I have imported one form and two modules from another database, in order to
compare code.
Having finished the comparison, I cannot delete them.

When I press 'Delete', I get a message asking for confirmation 'Do you want
to permanently delete etc', I respond 'Yes' but the object remains. No error
message is generated.

If I try to open the object in design view, I get a message:
'The form 'formname' is misspelt or refers to a form that doesn't
exist.....'.

I presume the objects have become corrupted??

I have previously imported and deleted objects like this with no problems at
all.
Has anyone else experienced this problem?
And if so, is there a solution other than importing all objects into a new
db?
--
Bob Darlington
Brisbane



Reply With Quote
  #2  
Old   
Allen Browne
 
Posts: n/a

Default Re: Cannot delete forms and modules - 01-03-2005 , 07:29 PM






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 still doesn't work you could import everything into a new database,
as described in the first symptom in this article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps.org.

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

Quote:
Using Access 2002.
I have imported one form and two modules from another database, in order
to compare code.
Having finished the comparison, I cannot delete them.

When I press 'Delete', I get a message asking for confirmation 'Do you
want to permanently delete etc', I respond 'Yes' but the object remains.
No error message is generated.

If I try to open the object in design view, I get a message:
'The form 'formname' is misspelt or refers to a form that doesn't
exist.....'.

I presume the objects have become corrupted??

I have previously imported and deleted objects like this with no problems
at all.
Has anyone else experienced this problem?
And if so, is there a solution other than importing all objects into a new
db?
--
Bob Darlington
Brisbane




Reply With Quote
  #3  
Old   
Bob Darlington
 
Posts: n/a

Default Re: Cannot delete forms and modules - 01-03-2005 , 11:27 PM



Thanks Allen.
I tried decompile with no luck.

--
Bob Darlington
Brisbane
"Allen Browne" <AllenBrowne (AT) SeeSig (DOT) Invalid> wrote

Quote:
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 still doesn't work you could import everything into a new
database, as described in the first symptom in this article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps.org.

"Bob Darlington" <bob (AT) dpcmanAX (DOT) com.au> wrote in message
news:41d9edb7$0$3440$afc38c87 (AT) news (DOT) optusnet.com.au...
Using Access 2002.
I have imported one form and two modules from another database, in order
to compare code.
Having finished the comparison, I cannot delete them.

When I press 'Delete', I get a message asking for confirmation 'Do you
want to permanently delete etc', I respond 'Yes' but the object remains.
No error message is generated.

If I try to open the object in design view, I get a message:
'The form 'formname' is misspelt or refers to a form that doesn't
exist.....'.

I presume the objects have become corrupted??

I have previously imported and deleted objects like this with no problems
at all.
Has anyone else experienced this problem?
And if so, is there a solution other than importing all objects into a
new db?
--
Bob Darlington
Brisbane






Reply With Quote
  #4  
Old   
Phil Stanton
 
Posts: n/a

Default Re: Cannot delete forms and modules - 01-04-2005 , 04:37 PM



Create a new database and import the items one at a time. I know it's a pain
in the backside doing it that way, but one of the items (in my experience,
usually a form) is corrupted. Probably have to do it several times to find
the corrupt item. You may get away with importing all the tables and queries
at one hit.

HTH
Phil

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

Quote:
Thanks Allen.
I tried decompile with no luck.

--
Bob Darlington
Brisbane
"Allen Browne" <AllenBrowne (AT) SeeSig (DOT) Invalid> wrote in message
news:41d9f15e$0$31805$5a62ac22 (AT) per-qv1-newsreader-01 (DOT) iinet.net.au...
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 still doesn't work you could import everything into a new
database, as described in the first symptom in this article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps.org.

"Bob Darlington" <bob (AT) dpcmanAX (DOT) com.au> wrote in message
news:41d9edb7$0$3440$afc38c87 (AT) news (DOT) optusnet.com.au...
Using Access 2002.
I have imported one form and two modules from another database, in order
to compare code.
Having finished the comparison, I cannot delete them.

When I press 'Delete', I get a message asking for confirmation 'Do you
want to permanently delete etc', I respond 'Yes' but the object remains.
No error message is generated.

If I try to open the object in design view, I get a message:
'The form 'formname' is misspelt or refers to a form that doesn't
exist.....'.

I presume the objects have become corrupted??

I have previously imported and deleted objects like this with no
problems at all.
Has anyone else experienced this problem?
And if so, is there a solution other than importing all objects into a
new db?
--
Bob Darlington
Brisbane








Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.