I'm using an example of the Alter Table statement from Microsoft's Developer Network website (https://msdn.microsoft.com/en-us/library/bb177883(v=office.12).aspx
), but I'm getting a syntax error. I changed the table and column names, but other than that, it's exactly like Microsoft's example. The table was created earlier with a make-table query. What am I doing wrong?
Set dbs = CurrentDb
dbs.Execute "ALTER TABLE RawList" & "ADD COLUMN TimesUsed INTEGER(10);"
I browsed topics and solutions, but didn't find an answer. TIA for any suggestions...