Beerman3436
10-07-2003, 08:35 AM
I need to know how to insert a new column in a table with a ADODB command. I tryed the append but it will not work.
|
View Full Version : ADODB Append Beerman3436 10-07-2003, 08:35 AM I need to know how to insert a new column in a table with a ADODB command. I tryed the append but it will not work. dcx693 10-07-2003, 09:25 AM It's ADOX that you need to use for data definition, not ADO. There are some good ADOX code samples in the Access help system (I'm using 2000 right now), including one called "AutoIncrement Column Example". Look in the Help under Microsoft ActiveX Data Objects, then Microsoft ADO Extensions for DDL and Security, then ADOX API Reference, then ADOX Examples, then finally "AutoIncrement Column Example". |