Rename a field by code.

[NKN]

Hi all,

Does anybody know how can I rename a field but not using the interface
provided by Office but by code. Is there any instruction I can execute?

I'm programing in VB and the batabase is Access from Office XP.

Thanks in advance,

Naiara.

 

[Nikos Yannacopoulos]

Naiara,

The syntax is:

CurrentDb.TableDefs("TableName").Fields("OldFieldName").Name =
"NewFieldName"

Note: if the table is opened or in use by another process (form, query etc)
the method will fail.

HTH,
Nikos

 

[NKN]

It works!! Thanks Nikos.

Naiara.

Naiara,

The syntax is:

CurrentDb.TableDefs("TableName").Fields("OldFieldName").Name =
"NewFieldName"

Note: if the table is opened or in use by another process (form, query etc)
the method will fail.

HTH,
Nikos