name change

[sadie]

I am using access 2003 and have a database with over 1500 rows
I have many queries and reports relating to this database
One of my agencies changed their name and I want to know what is the best way to change the name in the whole database, including queries and reports

 

[tehNellie]

At the risk of pointing out the obvious, changing the name of the agency in tblagency (or wherever you store your agency information) should ripple the effect throughout your whole database application if it's set up right.

Otherwise it's going to be a pain and depends on exactly where (and if) it's been "hardcoded" outside of that table.

 

[boblarson]

If the name is stored in more than one element in one table, then your database is NOT normalized and is incorrectly designed. What SHOULD happen is that if a name change occured then you would be able to open a form that has the data for their name and change it there. The other data stored in the database would be the foreign key (primary key from the table the data is stored in) in numeric (long integer) form and therefore it won't change, but is tied to the one data element within the organizations table (or whatever table the organization name is stored).

 

[sadie]

It helped to change it in the table
I had to clean up manually where it wasn't exact (case sensitive etc)