Rename field name in table

T

Tom

Using Access 2002 is it possible, using vb, to rename a field name in a
temporary table? If possible an sample of code would be appreciated

TIA

Tom
 
A

Allen Browne

No, you cannot rename a field.

You can:
1. CreateField()

2. Execute an UPDATE query statement to populate the new field with the
contents of the old one.

3. DROP the old field.
 
T

Tom

Thanks Allen works a treat

Tom
Allen Browne said:
No, you cannot rename a field.

You can:
1. CreateField()

2. Execute an UPDATE query statement to populate the new field with the
contents of the old one.

3. DROP the old field.
Click to expand...
 
Top