Deleting orphan code.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have just overhauled my database
(Access2003) in WindowsXP.

This involved deleting many forms and other
objects that I had been keeping just in case
of future need.

When I delete all these objects, does the old
code for 'buttons' and 'combos' etc remain
behind, or must I delete the background code
before I delete the object?

Is there any way to delete the dead code
*after* I delete the objects?

Frank
 
Frank Martin said:
I have just overhauled my database
(Access2003) in WindowsXP.

This involved deleting many forms and other
objects that I had been keeping just in case
of future need.

When I delete all these objects, does the old
code for 'buttons' and 'combos' etc remain
behind, or must I delete the background code
before I delete the object?

Is there any way to delete the dead code
*after* I delete the objects?
Click to expand...

Deleting the form, report or module will delete the code behind the
form, report or module attached to events or command buttons.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Frank Martin said:
Is there any way to delete the dead code
*after* I delete the objects?
Click to expand...

My previous posting aside you may wish to do a decompile just to
"flush" things out.

Decompile or how to reduce Microsoft Access MDB/MDE size and decrease
start-up times
http://www.granite.ab.ca/access/decompile.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
"Tony Toews [MVP]" <[email protected]>
wrote in message
My previous posting aside you may wish to
do a decompile just to
"flush" things out.

Decompile or how to reduce Microsoft Access
MDB/MDE size and decrease
start-up times
http://www.granite.ab.ca/access/decompile.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so
that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips &
Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -
http://msmvps.com/blogs/access/
Click to expand...

Thank you. Do I need to do the decompile
via your method when I am using Access2003,
because this has a "backup/compact database"
in the File menu?

I cannot get your method to work. My
database is in the folder "My Documents".
How can I apply your method there?

Frank
 
Thank you. Do I need to do the decompile
via your method when I am using Access2003,
because this has a "backup/compact database"
in the File menu?
Click to expand...

Decompiling and backup are totally different and unrelated activities.
I cannot get your method to work. My
database is in the folder "My Documents".
How can I apply your method there?
Click to expand...

Please post your code.


John W. Vinson [MVP]
 
To get the "full" path to "MyDocuments", you should be able to right-click
any MyDocuments icon, select Properties and copy the Target File setting.
(Or open Windows Explorer and browse to it and then copy the path from the
status bar, if that display option is turned on...).

In WinXP, the default is usually something like:
C:\Documents and Settings\<UserName>\MyDocuments\MyFile.mdb
But iirc, that has changed over various versions of Windows, and even then
it can vary widely from the default. I also have no idea what Vista's
settings are.

Then, as Tony says, the shortcut/command line is constructed out of the
following 3 elements:

"Full path to MSACCESS.EXE in quotes" "Full path to Your.mdb in quotes"
/decompile

HTH,
 
I could not figure to enter my question without entering as a reply. My
question does not pertain to your posting, but this is the only I can figure
out to get it in.

I have a document in Word 2003 that I cannot delete. I have tried all the
delete methods. I have even uninstalled the software and reinstalled and
this document will not go away. When you open up Word this document
automatically pops up and it will not let you enter a new document. Help!!!
 
I could not figure to enter my question without entering as a reply. My
question does not pertain to your posting, but this is the only I can figure
out to get it in.

I have a document in Word 2003 that I cannot delete. I have tried all the
delete methods. I have even uninstalled the software and reinstalled and
this document will not go away. When you open up Word this document
automatically pops up and it will not let you enter a new document. Help!!!
Click to expand...

You're asking in the wrong way... and in the wrong place. The "Access" in this
group name refers to the database software Microsoft Access, not to "computer
access".

Try going to
http://www.microsoft.com/office/com...osoft.public.word.docmanagement&lang=en&cr=US
and clicking the New... button on the left end of the toolbar.


John W. Vinson [MVP]
 
Back
Top