Having trouble with Create Index

[Glenn1203]

I'm trying to add a primary key (Unique Index) on a table via a SQL query,
but it's not working the way I expected. My SQL is:

Create Unique Index Unid
On mytable (Id);

I expected Access to add the new column "Id", but the query fails. After I
manually add the new column in the Design view the query runs, but the table
is not changed. I expected unique row numbers to be generated. Finally,
what is the function of index_name? I don't see that it adds anything, but
without it the query fails.

Thanks, Glenn

 

[Van T. Dinh]

Adding Fields (ALTER TABLE SQL) and creating Index (CREATE INDEX SQL) are 2
different actions.

It sound to me that you want to create a COUNTER / AUTOINCREMENT Field
(which is displayed as AutoNumber Field in the Table Design view).

Check the JET SQL Reference section of Access for the capitalised words /
phrases above.

 

[Glenn1203]

Thank you, that worked.

Adding Fields (ALTER TABLE SQL) and creating Index (CREATE INDEX SQL) are 2
different actions.

It sound to me that you want to create a COUNTER / AUTOINCREMENT Field
(which is displayed as AutoNumber Field in the Table Design view).

Check the JET SQL Reference section of Access for the capitalised words /
phrases above.