Your Opinion on Design Question

[Tony Toews [MVP]]

If you are such a "truly competent database professional", answer this:
Vendor appears in some VBA code, is Vendor a table or query?

Why does it matter?

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]]

Ten years of casual use of Access and following the Access newsgroups and reading Access books, and
ten years of seeing the tbl- prefix propagated upon wave after wave of new Access users. Sure, I
know the reason. Because it is just the right thing to use for Access tables.

But why is using tbl a prefix the right thing?

How else can a person
know whether Vendors is a table or a query?

What does it matter? No difference between a table or query other
than some queries aren't updatable.

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]]

Are you now going to jump in and object to every response with object
prefixes embedded?

Not at all. Just that if someone is going to start off designing a
system I wanted to point out some alternatives.

In this case,
it's far removed from the issue..

Shall we who embrace the Reddick naming convention jump on each of
your posts and make a big deal out of the fact that you *don't support
the most widely adopted naming convention for Access, VB and VBA*? We
would be equally justified. More so, I believe. The more widely
adopted the naming convention, the greater its value.

However I feel the naming conventions are a hindrance and are of very
little value. With the exception of VBA variables where I generally
do use them.

Too bad that your eagerness to refer to your own practices on your
site caused you to single out a post of Steve's. Others then piled
on. I don't know if you've been aware but his behavior has improved a
whole bunch over what it was in years past. He has been doing a lot
more responsible posting without the constant hustle of the unwary.

I hadn't even realized it was Steve Santos as it wasn't his usual
posting of paid help. I seldom read the names unless they stand out
and/or have last names I recognize as a regular.

Steve has been soliciting some lately though.

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]]

Are you now going to jump in and object to every response with object
prefixes embedded?

Oh, and no. I generally don't answer too many questions in the
tablesdbdesign newsgroup. I just look for interesting subjects. And
I have no idea how I define interesting. <smile>

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/

 

[Michael Gramelspacher]

But why is using tbl a prefix the right thing?


What does it matter? No difference between a table or query other
than some queries aren't updatable.

Tony

I did not mean for that to be taken seriously. I view using a prefix for tables as perhaps an
addiction. I had the addiction too once. At some point I was asked why I did that, and all I knew
to answer was that everyone else did it.

Here is a site with 100s of data models. I have seen people referred to the site from Access and
Sqlserver newsgroups. I do not think you will see and tbl- prefixes there.
http://www.databaseanswers.org/data_models/index.htm

And, of course, how about Northwind?