Re: Changing Linked Table Name

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Even though applications do evolve, you're not going to start storing PART
information in an ORDERS table. Explain to me why if 'ORDERS' accurately
describes the contents of a table that it would have to be renamed.

Furthermore (and more importantly), even if a more descriptive name is
developed such as 'CUSTOMER ORDERS', it begs the question if there is a
specific BUSINESS NEED to change the table name. Even if the table name is
mispelled as in 'ORDRES' , the mispelling does not rise to the level of
BUSINESS NEED and thus warrant a name change.

Even if you go to a Header/Detail model for customer orders where the
content of the ORDERS table will be the order detail, it does not
neccessarily warrant changing the name from 'ORDERS' to 'ORDER DETAILS'.
Yes, ORDER DETAILS in that scenario would be [more] descriptive, however it
all comes back to BUSINESS NEED. Will the DB still function if the table is
named 'ORDERS' although 'ORDER DETAILS' is more specific? Do you choose to
spend the time and effort to rename the table or is it just a matter of the
developer(s) knowing that ORDERS is actually ORDER DETAILS? Which costs more
in terms of labor? Will the DB cease to function if the table isn't
renamed?

"Jack Leach" <dymondjack at hot mail dot com> wrote in message
news:C6B7EF91-76C2-469D-A645-6D424F2E685D@xxxxxxxxxxxxxxxx
Some applications do have a tendancy to evolve. Not everyone has the
luxury
of knowing exactly what they are going to need 10 years from now, and when
the time comes to improve upon an old design, often things aren't
previously
what would be ideal presently.


--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"David C. Holley" wrote:

But how much time had you spent having to re-code as the result of
changing
a single file name?

Furthermore, if you have a table that's containing customer information,
why
isn't is name 'Customers' or 'CustomerInformation' to begin with? The
table
name should follow the contents of the table.

"Crystal (strive4peace)" <strive4peace2009@xxxxxxxxx> wrote in message
news:4B1AD8FC.7050107@xxxxxxxxxxxx
Hi David,

Personally I disagree that changing names is a sign of poor design.
When
I first design an application, I try very hard to create the final
names -- but there are often times where I think of something better
and
change them.

I also work with applications that other folks designed, a lot!
Changing
names is something I tend to do quite a bit -- in those cases, usually
so
much changes that we rewrite the code and redesign forms/reports too --
and your statement would surely be applicable, but changed names don't
really matter.

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access
(also includes links for Whistles and Bells, VBA chapters, sample
databases, etc)

*
(: have an awesome day :)
*


David C. Holley wrote:
There are those that would suggest that the need to change a table
name
is an indication of a poor design at the outset.



.



.

Relevant Pages

  • Re: Changing Linked Table Name
    ... Some applications do have a tendancy to evolve. ... Furthermore, if you have a table that's containing customer information, why ... Personally I disagree that changing names is a sign of poor design. ... Access Basics ...
    (microsoft.public.access.modulesdaovba)
  • Re: Exception Logging in C#
    ... coupled applications doing level 2 to level 5 controls. ... being written by third party customer consultants or the actual customer ... logging system for the process alarms but used the event log for system ... both in design and in implementation. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: question about component integration or assembly
    ... File Design and File Indexing ... Microcomputer Applications by Graurer and Sugrue p. 370, ... management system also provides the ability to delete records as well as add ... Programmers and database users also find SQL to be valuable ...
    (comp.object)
  • Re: defining quality of OOA and OOD models
    ... must be done) while an OOA model describes the solution (How it should ... Using the term "analysis" to mean "design" should, if nothing else, not ... bridge the chasm between customer problem spaces and the computing ... the problem space abstraction that dominates OOA is ...
    (comp.object)
  • VUI Designer Position available with eLoyalty
    ... eLoyalty Corporation is a leading management consulting, ... eLoyalty's broad range of enterprise Customer ... This creative and detail-oriented individual will design and consult on ... conversational speech applications, working to achieve exceptional ...
    (comp.speech.research)