 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / August 2004Naming Standard
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 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 > Is there a good link for a standard naming convention in > Access? [quoted text clipped - 7 lines] > > David 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/  SignatureBrendan 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. > The most generally-accepted naming standard is the Reddick Naming > Convention, derived from the Leszynski*-Reddick Naming Convention for Access [quoted text clipped - 24 lines] > > > > David Tony Toews lists some conventions at http://www.granite.ab.ca/access/tablefieldnaming.htm. He also has a couple links to other web pages. SignatureDuane Hookom MS Access MVP > Piggy-backing on Larry's post because I don't see the original ... > [quoted text clipped - 32 lines] > > > > > > David |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.