Add Indexed (Duplicated OK) to access database C#

[Chintan Shah]

I have an application which inserts large amount of data in Access database. So to speed up the things i have set Indexed property to No.

So at the end of insertion i need to set the index to the column of the one of the table to Indexed (Duplicates OK) through C#.

Help would be really appreciated.

Thanks

[Rabbit]

I don't know how you got rid of the index since you didn't post your code but you can probably just reverse whatever code you used to get rid of it.

[Chintan Shah]

Actually i removed directly from xxx.accdb access file.
I just want to add index through code to make reading faster.

I tried:

string addIndex = "CREATE INDEX columnName ON table(columnName) WITH IGNORE NULL";
OleDbCommand cmd = new OleDbCommand(addIndex, conn);
cmd.ExecuteNonQuery();

but it didn't work.

[Chintan Shah]

Actually worked .. changed the index name different then column name.

Thanks