Redundancy

[Lyle Fairfield]

I am preparing to write a small utility which will identify redundant
objects in an ADP and its SQL db.

Suppose my code finds two objects, A and B, which refer only to each
other, that is each calls a function from the other, opens the other or
uses a property of the other, etc, only. Assuming A an B are not menu
items, is it necessarily true that A and B are redundant to the
application and can be removed safely?

[Steve Jorgensen]

On Thu, 27 May 2004 10:12:38 -0400, Lyle Fairfield
<ly***********@netscape.net> wrote:

I am preparing to write a small utility which will identify redundant
objects in an ADP and its SQL db.

Suppose my code finds two objects, A and B, which refer only to each
other, that is each calls a function from the other, opens the other or
uses a property of the other, etc, only. Assuming A an B are not menu
items, is it necessarily true that A and B are redundant to the
application and can be removed safely?

In my opinion, yes, and let me know if/when you are successful with your
"small" utility. What you're trying to do might actually not be 100%
possible, given that so many things in such an application can be referred to
indirectly.

One can run a function using Eval, Run, etc., and one can run a class method
using CallByName, and of course, it's even more so with references to form,
report, and control names, and anything on the SQL Side which are often
referenced via text.

I know this is not new info to you, just wondering if you considered all that.

[XMVP]

"Lyle Fairfield" <ly***********@netscape.net> wrote in message
news:2h************@uni-berlin.de...

I am preparing to write a small utility which will identify redundant
objects in an ADP and its SQL db.

Suppose my code finds two objects, A and B, which refer only to each
other, that is each calls a function from the other, opens the other or
uses a property of the other, etc, only. Assuming A an B are not menu
items, is it necessarily true that A and B are redundant to the
application and can be removed safely?

See Aristotle's "Prior Analytics," Book 1, Chapter 13, "Preliminary
Discussion of the Contingent."

[Anthony Cuttitta Jr.]

I haven't had a chance to use it (since my Glorious Employers are
still using A97), but A2003 has a Dependant Objects feature which
appears to do what you're talking about.

Here's the link on the A2K3 tour and a description:
http://www.microsoft.com/office/acce...on122121120120

Any devs have any experience with it? I'd be interested to know too
(since SUPPOSEDLY we're beging upgraded later on this year).

Thanks,
Anthony.

Lyle Fairfield <ly***********@netscape.net> wrote in message news:<2h************@uni-berlin.de>...

I am preparing to write a small utility which will identify redundant
objects in an ADP and its SQL db.

Suppose my code finds two objects, A and B, which refer only to each
other, that is each calls a function from the other, opens the other or
uses a property of the other, etc, only. Assuming A an B are not menu
items, is it necessarily true that A and B are redundant to the
application and can be removed safely?

[XMVP]

"Anthony Cuttitta Jr." <ac*******@railvan.com> wrote in message
news:66**************************@posting.google.c om...

I haven't had a chance to use it (since my Glorious Employers are
still using A97)....

According to Expert MVP Larry Linson, ONLY Access 97 is suitable for
database applications. YOU'RE FIRED!

[Tony Toews]

"XMVP" <ac***********@hotmail.com> wrote:

Please ignore the above posting and others which are somewhat bizarre.

Note to persons new to this newsgroup. One person, with many identities, is being
rather disruptive. If you see a bizarre posting it's probably the work of this
disruptive person..

Check the headers of the posting. If you see the following the posting likely can be
ignored. Of course, there will likely be other headers to be added to this list.

Comments: This message did not originate from the Sender address above.
It was remailed automatically by anonymizing remailer software.
or
X-Abuse-Report: ab***@teranews.com
or
Organization: Posted via Supernews, http://www.supernews.com
or
Organization: 100ProofNews.com - Unlimited Downloads - $8.95/Month
or
X-Complaints-To: ab***@vnet-inc.com

You can also change your NewsReader program settings to ignore off-topic posts. See
http://www.hyphenologist.co.uk/killfile/ for more information.

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

[Salad]

XMVP wrote:

"Anthony Cuttitta Jr." <ac*******@railvan.com> wrote in message
news:66**************************@posting.google.c om...

I haven't had a chance to use it (since my Glorious Employers are
still using A97)....

According to Expert MVP Larry Linson, ONLY Access 97 is suitable for
database applications. YOU'RE FIRED!

http://www.trumpfiresbush.com/

[XMVP]

If you are tired of reading Tony's off topic, stupid and repetitive posts,
report him for spamming this newsgroup:
OrgAbuseName: Verio Abuse Contact
OrgAbusePhone: [phone]
OrgAbuseEmail: ab***@verio.net

[We Need Tony]

"XMVP" <ac***********@hotmail.com> wrote in message
news:uf********************@vnet-inc.com...

If you are tired of reading Tony's off topic, stupid and repetitive posts,
report him for spamming this newsgroup:
OrgAbuseName: Verio Abuse Contact
OrgAbusePhone: [phone]
OrgAbuseEmail: ab***@verio.net

hey xmvp dude--we professional database developers need tony. where would
we be without his obsolete web site filled with bogus advice?

[Tony Toews]

ac*******@railvan.com (Anthony Cuttitta Jr.) wrote:

I haven't had a chance to use it (since my Glorious Employers are
still using A97), but A2003 has a Dependant Objects feature which
appears to do what you're talking about.

Here's the link on the A2K3 tour and a description:
http://www.microsoft.com/office/acce...on122121120120

Any devs have any experience with it? I'd be interested to know too
(since SUPPOSEDLY we're beging upgraded later on this year).

I strongly suspect it wouldn't go through code looking for objects. Ah, in the A2003
help "It is not available for the following - Access projects, data access pages,
macros and modules in a database, and objects not supported by the name AutoCorrect
feature, such as action queries and SQL-specific queries, including union queries,
data-definition queries, pass-through queries, and subqueries."

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

[XMVP]

"Tony Toews" <tt****@telusplanet.net> wrote in message
news:pa********************************@4ax.com...

I strongly suspect it wouldn't go through code looking for objects. Ah, in the A2003 help "It is not available for the following - Access projects, data access pages, macros and modules in a database, and objects not supported by the name AutoCorrect feature, such as action queries and SQL-specific queries, including union queries, data-definition queries, pass-through queries, and subqueries."

[Ah, Tony is relevant!]