Relpace in multiple tables

[CanWest]

Here is my senario

I have a fairly large 2003 db with about 35 tables
Every table has a numeric feild call ChnageID
It is used to identify who was the last person to change that record
I discovered that there were duplicate users in the user end of the db and thus there were different values for the same person in ChangeID

I want an easy way to go to all of the tables and replace say 1181 with 1282 without creating an update query for each table. Is this possible?

 

[Galaxiom]

Unless you are reasonably expereinced in VBA just create one query and edit the tablename in the sql view after each run.

Otherwise create a dynamic query in VBA and loop through the table names.

You could either put all the table names in an array or use the tabledefs collection to get the table names.