Naming Standard

[David]

Is there a good link for a standard naming convention in
Access?

Microsoft says anything that is 64 characters or less.
SQL says, no spaces. I'm beginning to have a lot more
automation between tables, forms and queries and I am
strugling with making sure I reference the exact name.

Any assistance would be greatly appreciated.

David

 

[Larry Linson]

The most generally-accepted naming standard is the Reddick Naming
Convention, derived from the Leszynski*-Reddick Naming Convention for Access
2.0. It is documented in the _Access <versionnumber> Developers Handbook_,
by Litwin, Getz, et al, published by Sybex. In any case, I recommend that
serious Access power users and developers have a copy of that book -- Paul
Litwin told me there will be no Access 2003 edition, but the 2002 edition
should be fine for Access 2003 work.

* I beg pardon if I misspelled this name.

Microsoft has something on this in the Knowledge Base, but I have not
checked lately to see if it is up-to-date. Googling on the name might lead
you to an online description.

Larry Linson
Microsoft Access MVP

 

[Brendan Reynolds]

Piggy-backing on Larry's post because I don't see the original ...

The RVBA (Reddick VBA) naming (and also coding) conventions are available
on-line and also in downloadable PDF format at Gred Reddick's web site ...

http://www.xoc.net/

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Duane Hookom]

Tony Toews lists some conventions at
http://www.granite.ab.ca/access/tablefieldnaming.htm. He also has a couple
links to other web pages.