1 ) Write "LEFT JOIN" instead of "JOIN". I've forgot that Access has slitely different syntax then SQL Server does.



2 ) Make sure that macroses are on and allowed. I was wrong a bit too, here is exactly working string:

DoCmd.RunSQL("alter table [" + table.Value + "] add column [" + field.Value + "] " + ftype.Value)