Hello,
I am attempting to change the name of a column from Field1 to Field2 in Access2000 using VB6 SP4. Actually, it would be more useful and simpler (and less time consuming) if I was able to change the datatype of Field1 from Autonumber to Double (it is not a primary key), that would be great. Anyhow, this is the statement I am using to rename the column and it returns an error saying there is a problem with the statement.
Alter Table Table1 RENAME Column (Field1) To (Field2)
Thank You
I am attempting to change the name of a column from Field1 to Field2 in Access2000 using VB6 SP4. Actually, it would be more useful and simpler (and less time consuming) if I was able to change the datatype of Field1 from Autonumber to Double (it is not a primary key), that would be great. Anyhow, this is the statement I am using to rename the column and it returns an error saying there is a problem with the statement.
Alter Table Table1 RENAME Column (Field1) To (Field2)
Thank You
