I need to add a column to a bunch of Access 97 databases. The databases all have the same name and identical structures but they're in different folders.
If I open each MDB in Access 97 I can run a SQL query to add the column like this:
ALTER TABLE table1 ADD COLUMN field5 text(50)
However...