![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |