Many people here will post examples of code using prefixes such as tbl or vw
only because they are writing only a few lines of code instead of a full
database and they need to make these very few lines to be a much clear as
possible; with no other background.

Myself, I often write here things MyTable or MyView; however, I will never
use the names MyTable or MyView in one of MyDatabase.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Jamie Collins" wrote in message
ups.com...

Robert Morley wrote:
I've seen countless numbers of experienced, formally trained (and who
learned it on their own) database programmers on every platform I've ever
used who use "tbl" for tables, "vw" for views, "usp" for user stored
procedures, not to mention "frm" for forms, "rpt" for reports, etc., ad
nauseum.

I think the important word here is 'convention'.

It is an Access convention to prefix tables with 'tbl'. Wannabe Access
MVPs see established Access MVPs using the prefix so they imitate them;
in turn Access MVPs use the prefix because it's what their audience
expects i.e. to do Access things in an Access way.

Bottom line: use the 'tlb' prefix if you want to appear to be a true
blue Access user. How that affects your reputation as an amateur or
otherwise will largely be determined by where you are posting your
reply e.g. contrast the Microsoft.Public.Access.GettingStarted group
with comp.databases.theory.

My advice: if you want to appear as a 'serious' SQL database type
person, take a look at what people do outside of the Access ghetto.
You'll find the debate focuses on whether to pluralize table names
(e.g. Customer or Customers) and that prefixes are not rarely used at
all, other than as a hangover from a port from Access.

Jamie.

--