View Single Post
  #1  
Old December 18th, 2009, 04:24 PM posted to microsoft.public.access.tablesdbdesign
Chris Moore[_2_]
external usenet poster
 
Posts: 23
Default Change all Names: objects, fields, code, etc.

Access 02 sp3 on XP sp2.

So, I have inherited a access database from my predesessor that gathers and
reports financial data for the previous year and current year-to-date. As a
result, many of the table names and column headers have names specifically
referencing "2008" and "2009". I now need to modify this database for the
approaching new year. Everything that says "2008" will need to be changed to
"2009" and everything that says "2009" will need to be changed to "2010".
Unfortunately this also means that all the queries, forms and modules that
reference these names also need to be updated. In short it's a mess.

Is there any way to globally search a database for any and all references to
a particular value and replace that value with another? It's all just code
after all, right?

Thanks in advance for any help offered.

-Chris