Modify a column name in a table?

[Tony Nielsen Hanna]

Hi!

I'm working with ASP and an Access database.

How does a SQL string look that modifies an column name in a specific table?

f.eks.

SQL = "ALTER TABLE tablename Modify......

I have tried this, but it doesn't work. Perhaps I don't know how to
configure it properly.

Please give me a helping hand.

Thanks

Yours Sincerely

Tony N. Hanna

[Michel Walsh]

Hi,

I don't remember to have seen a MODIFY, only an ADD and a DROP. You can take
a look in chapter 5 of "Access 97 Developer's Handbook" at Sybex (not the
one with a similar name, at MSPress).

Hope it may help,
Vanderghast, Access MVP.

Tony Nielsen Hanna wrote in message ...