View Single Post
  #1 (permalink)  
Old 10-23-05, 13:52
accessman2 accessman2 is offline
Registered User
 
Join Date: Sep 2005
Posts: 313
How to rename the column name in MS Access table

Hi:

MS Access
In query:
I write

ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

But, it doesn't work, because "Rename" is NOT avaliable.
How can I fix that?

Thanks.
Reply With Quote