I am using the help "CreateField Method" example in MSN help to create a new
Field in an existing Database.Table.   As this example create also a new
Table I try to make changes so it can open a new Field without opening a new
Table.

I tried different Changes without success.  Is it because it is no feasible?

I would appreciate if somebody can help me?

Thanks in advance for your help!

For what it is worth here is a different method I just used. idxData is an
open DB, tmpTable is the table and IDD is the new field. I'm kinda new at this
vb stuff but it works.

    'add a field
    idxData.Execute "ALTER TABLE tmpTable ADD COLUMN IDD long;"

says...

I took exception to your recent:
[ ] Email
[X] Post to this newsgroup

It was (check all that apply):

[ ] Stupid
[X] Clueless
[ ] Imbecilic
[ ] Boring

Your attention is drawn to the fact that:
[X] You posted Visual Basic Questions to Visual DBASE groups
[ ] You are trying to make money on a non-commercial newsgroup
[X] You don't know which group to post in
[ ] You posted something totally uninteresting
[X] You make no sense
[ ] You posted a stupid pyramid money making scheme
[X] You have greatly misunderstood the purpose of this newsgroup.
[X] You are a loser.

It is recommended that you:

[X] Get a clue
[ ] Get a life
[ ] Never post again
[ ] Drop dead
[ ] stick to FidoNet and come back when you've grown up
[ ] Put your home phone number in your ads from now on
[X] Refrain from posting until you have a vague idea what you're doing

In Closing, I'd Like to wish you:

[ ] A happy suicide
[ ] An untraceable bug
[ ] No replies
[X] Only replies from trolls
[ ] Most of the above