hi, i would like to know how to add fields to an already created table. i am using visual c++, ado, and access database file for my database. the .mde file is already created with existing tables and existing data in those tables. i am trying to use visual c++ and ado to open one of the existing tables, add fields/columns to that table, then close and save changes. can anyone give me a vc++ example how i can go about doing this?

thanks in advance