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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Import files into access 1
Access Click in Table to Open Form 0
renaming tables and forms automation at form coding 2
Rename File 3
how to rename a table using field name 1
Listbox selection to table 8
How to change field name in a table 4

Back
Top