Here are some SQL statements I use for this:

A Long Datatype:

    "ALTER TABLE tYourtable ADD COLUMN YourField LONG"

A YesNo Datatype:

    "ALTER TABLE tYourtable ADD COLUMN YourField YESNO"

A Text Datatype, 10 characters long:

    "ALTER TABLE tYourtable ADD COLUMN YourField TEXT(10)"

I just run these with an ADO Connection object, EXECUTE method.

Good luck,

Gregg


----- Original Message -----
From: Pawan <yadavp_2000@y...>
To: professional vb <pro_vb@p...>
Sent: Friday, October 13, 2000 8:30 AM
Subject: [pro_vb] field name


> Friends,
>
> How to add a new  field in the existing table on a fly.
>
>  I am using a access table which has 10 table and in one of the table I
want
> to append a field. Is it possible ?.
>
> Please give your expertise.
>
> -Pawan