Replace data in all tables

[Martin]

Hello,

I work with a database that has about 30 tables each with a list of stores,
the store ID and then different data such as sales, staff etc.

On occasions the store name or identifyer will need changing. At present I
open each table and undertake a find and replace to make the changes.

My question is can I automate this via VBA? I think I need to create some
SQL that loops for each table def but I have no idea how to do this or even
if that is the correct way to solve the problem.

Any help on this would be greatly appreciated.

Martin

 

[Ryan]

Do you have a table with a list of your stores? If not then your database
design may need to be rethought. If you had a table with all your stores ,
then you could just relate that table to the rest of your tables, and make a
dropdown selection for your store in each of your other tables.