I ended up using ADOX. Even then I have to create new table with the columns in the right order, and then copy the data from the old table; I can't seem to simply re-arrange the column order of an existing database.
---MikeB
This is for "admins" who are modifying tables and queries for end users. It would make it easier for them. Currently, they use MS Access, and I want to give them the same features as MS Access without having to buy them each a copy.
I agree it's not terribly important, but I've duplicated most...
I'm trying to insert a column in a MS Access table. I can append it fine, but I don't want it as the last column. The table has data, so I don't want to delete columns. I suppose I can clone the table one field at a time, inserting the new column, then populate the new table with the data, then...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.