Rename of fieldname in tabel ?

Det tror jeg ikke man kan - ikke i ét skridt  i hvert fald, med sql eller docmd.

Man kan med 3 skridt i sql, men det er så med den ineffektivitet at data bliver kopieret og slettet.
1.alter tabel add column newfield <type specification>
2.update table set newfield=oldfield
3.alter tabel drop column oldfield

Men der eksisterer tilsyneladende en funktion dertil i adox

https://tzuhsun.wordpress.com/2009/05/03/rename-field-in-ms-access-using-adox-cnet/

You can rename a column name of a table by ALTER TABLE statement.

Syntax:

ALTER    TABLE    table_name

RENAME  COLUMN  column_name  TO  new_column_name;

Example:

ALTER    TABLE    EMPLOYEE

RENAME  COLUMN    salary    TO    salary_amount;

In the above example, the SALARY column of the EMPLOYEE table has been renamed to the new name SALARY_AMOUNT by ALTER TABLE statement.

CurrentDb.TableDefs("TableNameGoesHere").Fields("OldFieldNameGoesHere").Name = "NewFieldNameGoesHere"

I know its not sql or docmd but if you can use docmd then why not something else ;-)

Thanks, great you could use it :-)