If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can Access database have secondary key?
Hi,
I'm trying to add key in to my tables. Is it possible to add secondary key? Thanks, Sarah |
#2
|
|||
|
|||
By definition you cannot have multiple primary keys.
You can have a primary key that is composed of multiple fields. You can have additional indexes that are composed of either a single field or multiple fields. To view/change index definitions for a table the easiest way is to open the table in design view and then select View-Indexes from the main menu and define any additional indexes you want. You can have a maximum of 32 indexes for a single table; you can have a maximum of 10 fields per index. "sg" wrote in message ... Hi, I'm trying to add key in to my tables. Is it possible to add secondary key? Thanks, Sarah |
#3
|
|||
|
|||
Bill,
That's great help. Thanks so much, Sarah "Bill Edwards" wrote in message ... By definition you cannot have multiple primary keys. You can have a primary key that is composed of multiple fields. You can have additional indexes that are composed of either a single field or multiple fields. To view/change index definitions for a table the easiest way is to open the table in design view and then select View-Indexes from the main menu and define any additional indexes you want. You can have a maximum of 32 indexes for a single table; you can have a maximum of 10 fields per index. "sg" wrote in message ... Hi, I'm trying to add key in to my tables. Is it possible to add secondary key? Thanks, Sarah |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 09:20 AM |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |