Relationship advice

On Thu, 7 Aug 2008 09:46:43 -0700, "Larry Daugherty"
wrote:

Tradition!? Pfui! Access hasn't been around all that long. The
references to history was simply to indicate where the sheer numbers
of people familiar with the naming conventions have arisen. It was
hardly an obeisance to tradition. The argument advanced was about
adopting a naming convention. Further, as between naming conventions
of roughly comparable technical merit, the one that is most widely
used among practitioners of the craft under discussion has the greater
value.

If your studies and your judgement and your own value system show you
a better way then it behooves you to adopt that one. If you believe
that it would benefit others then share it and champion it.

To which Access 2003 templates do you refer? I haven't analyzed
anything from Microsoft in a long time.

I don't see anything in your post that gets into the merits of any
particular naming convention nor that makes any good arguments toward
having none at all.

--
-Larry-

The templates are he
http://office.microsoft.com/en-us/te...nstalled=1&c=0

There are even more templates for Access 2007, but I do not have Access 2007.

I suggest thatnew users look at them and decide which way they wish to go. Lots
of people have done that, because one template I looked at had more than 370,000
downloads. I wonder if Microsoft has a paper detailing the object naming rules
these templates follow.

In practise I never encountered any issues with using table names without the
prefix.

"Steve" wrote in message
m...
A simple question for your vast expertise and MVP credentials .........

Suppose in an application's code you see reference to an object named
"Customer". Is that object a Table or a Query?

Steve


"Tony Toews [MVP]" wrote in message
...
"Steve" wrote:

First off, I suggest starting the name of all your tables with "Tbl".

I disagree. I've never seen any use in using an object prefix such
as tbl, qry, frm, rpt, etc. Indeed, in a database with a large
number of objects this can really slow you down.

Tony's Object Naming Conventions
http://www.granite.ab.ca/access/tony...onventions.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/

I guess the great "MVP" is only good at disagreeing but can not answer a
simple question!!!!!

Steve


"Steve" wrote in message
m...
A simple question for your vast expertise and MVP credentials .........

Suppose in an application's code you see reference to an object named
"Customer". Is that object a Table or a Query?

Steve


"Tony Toews [MVP]" wrote in message
...
"Steve" wrote:

First off, I suggest starting the name of all your tables with "Tbl".

I disagree. I've never seen any use in using an object prefix such
as tbl, qry, frm, rpt, etc. Indeed, in a database with a large
number of objects this can really slow you down.

Tony's Object Naming Conventions
http://www.granite.ab.ca/access/tony...onventions.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/

Keep your pants on stevie, you have caused more problems than you are worth
and you are surprised some of the regulars ignore you?

You have a rather mixed opinion of Tony. One hand you insult him and on the
other you point people to his website as a great resource.

As to your question, my preferred answer is table. Though I would never
refer to a table in the singular, so my table would be "Customers". Why, I
have done DB work since the sixties, yes stevie, there were databases back
then, and always found the type tagging to be superfluous. Tables should be
objects and queries should have an action or qualifier to them. Referring to
a query as "Customers" brings up question "Which customers?". So the query
name should have a qualify.

John...

John...
"Steve" wrote in message
m...
I guess the great "MVP" is only good at disagreeing but can not answer a
simple question!!!!!

Steve


"Steve" wrote in message
m...
A simple question for your vast expertise and MVP credentials .........

Suppose in an application's code you see reference to an object named
"Customer". Is that object a Table or a Query?

Steve


"Tony Toews [MVP]" wrote in message
...
"Steve" wrote:

First off, I suggest starting the name of all your tables with "Tbl".

I disagree. I've never seen any use in using an object prefix such
as tbl, qry, frm, rpt, etc. Indeed, in a database with a large
number of objects this can really slow you down.

Tony's Object Naming Conventions
http://www.granite.ab.ca/access/tony...onventions.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/

On Fri, 8 Aug 2008 15:59:34 -0400, "John... Visio MVP"
wrote:

As to your question, my preferred answer is table. Though I would never
refer to a table in the singular, so my table would be "Customers". Why, I
have done DB work since the sixties, yes stevie, there were databases back
then, and always found the type tagging to be superfluous. Tables should be
objects and queries should have an action or qualifier to them. Referring to
a query as "Customers" brings up question "Which customers?". So the query
name should have a qualify.

John.

I am a bit puzzeled why Steve thinks the question is important. How do I know
whether Kelly is a boy or a girl? Easy enough to find out, if it is important.
Look in the tables (boys) tab. Is he there? ne, then she is a girl.

SELECT * FROM Customer; Here customer is a table.
SELECT * FROM Customer; Here customer is a query. (Different database, but I
think SQL Server would allow it.)

Me.recordsource = "Customer" Does Access balk and ask whether it is a table or
a query name?

As you say, the table should be Customers; the query might be Get All Customers.

If Steve printed a relationship chart and showed it to a person vaguely
familiar with databases, would it be beneficial for the person to see names like
TblCustomer, TblEmployees, etc.? And if the person were to ask why everything
starts with Tbl-, would he say that it's so you know they are tables. Because
the person asks, "it could be something else?"

I think Access does not have a good reputation in the wider SQL community. This
is mostly unjustified in my opinion. Maybe ditching the prefixes was a
Microsoft attempt to move Access up in the world. No longer will programmers
know that a database originated as an Access database.

Just my opinion. I know all my lights do not go on all the time.

Many people may find such a simple template usable as it is. Many
developers may find that manifestation of Access utilization a great
basis for launching their own development projects. The subject
template showcases some of the technology embodied within Access.
However, IMHO it falls woefully short of documentation standards
suitable for projects delivered to clients.

The prefixing of object type mnemonics to objects was the impetus of
this thread. By extension that means "documentation".

Everyone is free to adopt their own documentation practices from
preferred naming conventions to no standardization whatever. No
matter how phrased, recommendations are what come out of these
threads, not laws.

HTH
--
-Larry-
--

"Michael Gramelspacher" wrote in message
...
On Thu, 7 Aug 2008 09:46:43 -0700, "Larry Daugherty"
wrote:

Tradition!? Pfui! Access hasn't been around all that long. The
references to history was simply to indicate where the sheer
numbers
of people familiar with the naming conventions have arisen. It was
hardly an obeisance to tradition. The argument advanced was about
adopting a naming convention. Further, as between naming
conventions
of roughly comparable technical merit, the one that is most widely
used among practitioners of the craft under discussion has the
greater
value.

If your studies and your judgement and your own value system show
you
a better way then it behooves you to adopt that one. If you
believe
that it would benefit others then share it and champion it.

To which Access 2003 templates do you refer? I haven't analyzed
anything from Microsoft in a long time.

I don't see anything in your post that gets into the merits of any
particular naming convention nor that makes any good arguments
toward
having none at all.

--
-Larry-

The templates are he

http://office.microsoft.com/en-us/te...nstalled=1&c=0

There are even more templates for Access 2007, but I do not have
Access 2007.

I suggest thatnew users look at them and decide which way they wish
to go. Lots
of people have done that, because one template I looked at had more
than 370,000
downloads. I wonder if Microsoft has a paper detailing the object
naming rules
these templates follow.

In practise I never encountered any issues with using table names
without the
prefix.

"Steve" wrote:

A simple question for your vast expertise and MVP credentials .........

Suppose in an application's code you see reference to an object named
"Customer". Is that object a Table or a Query?

Very likely a table but what does it matter? You can use them the
same in other objects and code.

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/

"Steve" wrote:

I guess the great "MVP" is only good at disagreeing but can not answer a
simple question!!!!!

So I don't check the newsgroups for a day due to illness and you're
complaining?

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/

"Larry Daugherty" wrote:

I thought you were above cheap tricks. :-) You cut a paragraph from
my post and then inserted your reply after the omission. That changes
the apparent sense of things. Your subsequent argument had already
been rebutted by the paragraph you cut out.

No, I'm trim a lot. I felt that paragraph was quite irrelevant.

"The greater the number of developers who will readily understand the
notations within an application, the more readily and inexpensively
the application can be maintained and extended. That's especially
true if the more widely published convention is the better one.
That's still true if the naming conventions have only equal value."

I don't see how that makes a difference. In my opinion the
uselessness and troublesome of tbl, qry, frm and rpt prefixes far
overrides any usefulness in a team environment.

That said I seldom work in a team environment.

It's my belief that you know more things about Access than I do.
Would you believe that I didn't know that Access wouldn't let a
developer give a table and a query the same name? In my ignorance it
must have been just pure dumb luck all these years...

My table and query names tend to be very different anyhow. A table
name is succinct, if at all possible, while query names tend to be
relatively verbose and wordy.

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/

The paragraph you cut and ignored was there because it was very
relevant to the discussion at hand.

Our opinions as to the worth of a notation system to ourselves
personally obviously differ. We're free to differ. :-)

I rarely work as a part of a software development team anymore.
However, when I complete a custom application for a client I provide
the source code for future maintenance. That is done with the
assumption that someone will eventually have to change things to
reflect changed business needs. The future developer, whether it's me
or someone else, benefits from the naming convention. I have never
once picked up some of my old code for analysis prior to change and
said to myself that the documentation, at any level, was a waste of
time. Most Access projects aren't team development endeavors. They
tend to be serial solo efforts.

I see from a different part of this thread that you've been ill. I
hope that you're well now and that you stay that way.

--
-Larry-
--

"Tony Toews [MVP]" wrote in message
...
"Larry Daugherty" wrote:

I thought you were above cheap tricks. :-) You cut a paragraph
from
my post and then inserted your reply after the omission. That
changes
the apparent sense of things. Your subsequent argument had already
been rebutted by the paragraph you cut out.

No, I'm trim a lot. I felt that paragraph was quite irrelevant.

"The greater the number of developers who will readily understand
the
notations within an application, the more readily and inexpensively
the application can be maintained and extended. That's especially
true if the more widely published convention is the better one.
That's still true if the naming conventions have only equal value."

I don't see how that makes a difference. In my opinion the
uselessness and troublesome of tbl, qry, frm and rpt prefixes far
overrides any usefulness in a team environment.

That said I seldom work in a team environment.

It's my belief that you know more things about Access than I do.
Would you believe that I didn't know that Access wouldn't let a
developer give a table and a query the same name? In my ignorance
it
must have been just pure dumb luck all these years...

My table and query names tend to be very different anyhow. A table
name is succinct, if at all possible, while query names tend to be
relatively verbose and wordy.

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/