PrimaryKey

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
F

Frank Dulk

The name of the index was PrimaryKey. Then I altered in user's " code for "
primarykey " and gave right.

Now it is one he/she doubts: did I look at other tables that I have and the
name of the index this equal to the name of the field, then, because Access
for now creates the index with the name of the field, for now not?. does
Have some thing with the field type used for the index to be?
 
Frank Dulk said:
The name of the index was PrimaryKey. Then I altered in user's " code
for " primarykey " and gave right.

Now it is one he/she doubts: did I look at other tables that I have
and the name of the index this equal to the name of the field, then,
because Access for now creates the index with the name of the field,
for now not?. does Have some thing with the field type used for the
index to be?
Click to expand...

If the index is created by selecting the field in table design view and
clicking the "Primary Key" toolbar button (or the Edit -> Primary Key
menu option), then Access creates the index with the name "PrimaryKey".
If you create an index by selecting the field and setting its Indexed
property to Yes, then Access will create the index with the same name as
the field.
 
Thank you Dirk.

Dirk Goldgar said:
If the index is created by selecting the field in table design view and
clicking the "Primary Key" toolbar button (or the Edit -> Primary Key
menu option), then Access creates the index with the name "PrimaryKey".
If you create an index by selecting the field and setting its Indexed
property to Yes, then Access will create the index with the same name as
the field.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top