Add fields to a table through code

[Riamor]

Hi Here is I have to do. I have to add two fields to a table called Schedule. Only problem is, this table is in over 100 databases. I have the list of databases in a table. Is there a way I can loop through each database, and add the two fields to the table? I've never modified a table through code, so I have no idea where to start. Thanks Diarmuid

[ajetrumpet]

check this out: http://www.access-programmers.co.uk/...le+information

portions of it can be extracte for you to get done what you want

[Riamor]

Thanks, that works.