Update Name Change Across All Access Tables

[Jessica240]

Hello,

My database contains multiple tables that contain a field for employee name. One of our employees' changed their name so now I need to change the name from "Bob Smith" to "Robert Smith" in all tables.

What is the most efficient method of doing this? I know how to run update queries, but is there a way to tell Access to simply search for "Bob Smith" in all fields of all tables and change it to "Robert Smith?"



I'm imagining something similar to Microsoft Word's Find and Replace but for a database.


Thanks in advance,
Jessica

[rpeare]

Why are you storing the name instead of the foreign key to your person table? if you did it this way (the whole point of relational databases) the name would be 'fixed' in all tables.

i.e.

tblEmployee
E_ID  E_LastName  E_Firstname
1     Smith       John
2     Jane        Doe

tblEmployeeTime
ET_ID  E_ID  ET_Date  ET_Hours
1      1     1/1/2018 6.5
2      1     1/2/2018 8

I would attempt to update your table structure to fix the employee reference rather than trying to update a text field.

[ranman256]

the name should be stored in only 1 table.
all others should have keys refering to that table to read the 1 name.