View Single Post
  #91  
Old August 25th, 2007, 02:35 AM posted to microsoft.public.access.gettingstarted
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Best Practice for tables?

"David W. Fenton" wrote:

It seems to me that you make more problems for yourself than you
solve. To me, having to use brackets all the time is *much* worse of
a maintenance issue than translating the coder-friendly names into
human-friendly names.


Not at all. If it was a PITA putting in square brackets then I would
have noticed. It's not.

When I need an object name I go to the database container window,
pretend I'm going to rename the object and grab the name. I'm done.
What could be simpler?

Problem solved for both users and coders, and without needing to
maintain a translation table or extra properties -- all you'd need
to do is follow your naming conventions and camel case everything at
each word break.


But not worth it to me. My system works and it's no trouble at all.
You're trying to solve a problem that doesn't exist.

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/