How to apply a group of changes

J

JL

I have hundreds of access files in the same format. Now I want to change the
design (adding 2 more fields for each of them). It's a real pain if I have
to do them one by one. Any shortcut?

They are very simple access files with one table only. The table has 2 text
fields. I want to add 2 more text fields and change the name of a existing
field. Thanks a lot for all your help.
 
D

Dirk Goldgar

JL said:
I have hundreds of access files in the same format. Now I want to
change the design (adding 2 more fields for each of them). It's a
real pain if I have to do them one by one. Any shortcut?

They are very simple access files with one table only. The table has
2 text fields. I want to add 2 more text fields and change the name
of a existing field. Thanks a lot for all your help.
Click to expand...

You could write a procedure that opens a given database (specified by
the fully qualified path and name), as a DAO Database object, executes
SQL ALTER TABLE statements against that object and/or uses the DAO
TableDef and Field objects to modify the table design, and then closes
the database. Then you'd just call this procedure for each database you
want to change. If the table name is not always the same, you'd
probably have to pass the table name to the routine, too.
 
Top