Add Index (Alter Table)

[mans]

Hello,

From within VB6 and using Access2000, I am attempting to change a field called field1 so it is indexed, the table name is Table1. I have used the following statement (and some variations) without luck. It says there is an error with the statement and higlights INDEX below.

Alter table table1 ADD INDEX field1

I would greatly appreciate any help.

Thank You

 

[johnwm]

Try this. Indexname must be a unique name in Table1

CREATE INDEX indexname ON table1(field1)

This runs as a straightforward SQL statement
Let me know if this helps

 

[mans]

Tahnk you very much, it works.