I'm writing a script that will automatically check a table to make sure it has all the fields, and add any missing ones. I'm getting a syntax error on this line:
Conn.Execute "ALTER TABLE Versions ADD Major integer(3)"
I was also wondering if there was a list anywhere of all the data types for Access. I haven't been able to find anything on specific Date/Time field types, or how to create a memo field.