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