To add new fields to a table I've been using something like:
CurrentDb.Execute ("ALTER TABLE MyTable ADD COLUMN NewField(x);")
This works fine but adds the fields to the end. Is there a way change where the field is added?
I know that generally the field order makes no difference since I can set order in a query, but this is for an app where I have from 0-10 fields added at runtime and then display the table. Also the field names are not consistent. Any ideas?
Thanks!