I am trying to change the column type of a field in my table with this statement
Note - tbl is me looping thro an array of tables but for brevity sake I just hardcoded the name, yes it is a valid table name and properly spelled
but I am getting this errorCode:tbl = "Products" strSQL = "Alter Table [" & tbl & "] Alter Column [UPC] Short Text" db.Execute strSQL
Code:Run-time error '3293': Syntax error in ALTER TABLE statement