Adding value

  • Thread starter Thread starter Chris25
  • Start date Start date
C

Chris25

Hi,

In my database, I have to add each time a new field to
some tables.

And after I have to put this field in the code, exemple
in a query, how can I do it automatically

that's mean, can I made a code to add automatically the
new field on my code, without obliged me to searche each
query and sub where i used this table


Thanks
 
Hi,

In my database, I have to add each time a new field to
some tables.

And after I have to put this field in the code, exemple
in a query, how can I do it automatically

that's mean, can I made a code to add automatically the
new field on my code, without obliged me to searche each
query and sub where i used this table
Click to expand...

This is one reason that it's critical to do a THOROUGH table design
*first* - this process can be a real pain! Adding fields to a table
should ideally never happen; if it must, then you pay the price.

There are some third-party tools to find all references to a table (or
other object):

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com
 
Back
Top