Rename field name in table

  • Thread starter Thread starter Tom
  • Start date Start date
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
 
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.
 
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...
 
Back
Top