Replace data in all tables

  • Thread starter Thread starter Martin
  • Start date Start date
M

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
 
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.
 
Back
Top