Append Column after copying a table

  • Thread starter Thread starter Lesley
  • Start date Start date
L

Lesley

Hi, Is it possible to append a new column to a table using
an Access macro?

CopyObject/Table is fine, but then I have to change the
table structure to accomodate a new field on a user input
form.

Thanks,

Lesley Regan
 
Lesley,

Depending on the details of the purpose you are trying to achieve, here
are a couple of ideas to consider...
- Make a Make-Table Query based on your existing table, with the extra
field added to the query design, and then use an OpenQuery action in
your macro to make it happen.
- Use a RunSQL macro action to run a ALTER TABLE statement.
 
Thanks, Steve.

I've been working with VBA and Word VBA too long -- I had
to remember the Queries in Access. Thanks for your
elegant solution.

Lesley
 
Back
Top