Alter Table Remove Index

[ADiecidue]

I'm using an Access 2003 database with VB2008. I recently posted regarding using ALTER TABLE to Rename columns. Since that did not work, I decided to Create a new column, copy the data from the old column then Delete the old column. The problem is that columns that are Indexed will not delete. Is there a way to set the Indexed property of those columns to "NO" then delete them?
--Tony--

 

[MattP]

I believe the syntax to drop an index in Access is

DROP INDEX index_name ON table_name

 

[ADiecidue]

I used the code below, even though it doesn't seem right and it didn't work.

db.Execute("ALTER TABLE Insurance2 DROP INDEX [Patient's Zip Code] ON Insurance2;")

I also tried:

db.Execute("ALTER TABLE Insurance2 DROP INDEX [Patient's Zip Code];")

With no success either.

 

[Stonkie]

See the first one here : http://www.w3schools.com/SQL/sql_drop.asp

In Access (Jet), you just write "DROP INDEX [Patient's Zip Code] ON Insurance2" without the ALTER TABLE keywords...

 

[ADiecidue]

Thanks... I just figured that out late last night and it seems to work. Now can I do the same with the PRIMARY KEY?