Thanks everyone for the comments. I'm currently in the process of manually
making all the necessary design changes so this won't have to be done again
in the future. The only trick I thought of to make the job a little easier
was to use the documenter to output all the SQL so I can search the document
to see if there are any references that I missed.

".Len B" wrote:

Whoa!! If you rename a table named x2009 containing data for 2009 to
x2010 and you also
rename the fields do you not now have 2009 data in a 2010 table with 2010
field names?

Apart from a redesign, wouldn't it be just a case of adding new set of
tables for 2010 and
modifying the queries or making new ones. Then everything still works or
its just a matter
of changing the RecordSource of forms and reports?
--
Len
__________________________________________________ ____
remove nothing for valid email address.
"Chris Moore" wrote in message
...
| 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



.