Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Insert (not Append) Column using ADO?
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- MBro2
- Post #5
- Forum: Visual Basic (Classic)
-
Insert (not Append) Column using ADO?
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...- MBro2
- Post #3
- Forum: Visual Basic (Classic)
-
Insert (not Append) Column using ADO?
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...- MBro2
- Thread
- Replies: 15
- Forum: Visual Basic (Classic)
