Search results

  1. N

    SQL query to ALTER TABLE ADD COLUMN in Access database

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