changing file size from single to double in many tables and fields

E

easywayout

i have a relational db that has 70+ tables, many of these tables have several
fields within that have the field size set to single, I need to update ALL
these fields in about 20 tables total to field size double. Does any one
know of a macro or some "Script" I could run in MS Access (or another tool if
needed) to mass update these fields so that i don't have to change the fields
one by one in each table?

something like...

all field size = Single, change to field size = Double
 
Top