ADODB Append

[Beerman3436]

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]

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".