By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,171 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Cannot delete forms and modules

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <bo*@dpcmanAX.com.au> wrote in message
news:41**********************@news.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

Nov 13 '05 #2

P: n/a
Thanks Allen.
I tried decompile with no luck.

--
Bob Darlington
Brisbane
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.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" <bo*@dpcmanAX.com.au> wrote in message
news:41**********************@news.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


Nov 13 '05 #3

P: n/a
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" <bo*@dpcmanAX.com.au> wrote in message
news:41***********************@news.optusnet.com.a u...
Thanks Allen.
I tried decompile with no luck.

--
Bob Darlington
Brisbane
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.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" <bo*@dpcmanAX.com.au> wrote in message
news:41**********************@news.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



Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.