Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

primary key help

Status
Not open for further replies.
faxof

faxof

Programmer
Dec 5, 2001
272
GB
how do i set a tables primary key using code?
 
Sort by date Sort by votes
You'll have to create a new index for the table as well as set the Primary property to true. You can find example code for this in the Access help under "Primary Property (DAO)".

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kirk Thomas
  • Locked
  • Question
Table Relationships newbie needs help
Replies
8
Views
226
johnherman
johnherman
cortextual
  • Locked
  • Question
Referential integrity issue: no unique index found for the referenced field of the primary table
Replies
2
Views
356
MajP
MajP
Moss100
  • Locked
  • Question
Designing a table's primary key.
Replies
4
Views
76
Moss100
Moss100
Moss100
  • Locked
  • Question
Which value do I store in the primary table from a support or lookup table? 4
Replies
15
Views
261
MajP
MajP
Magnolia1
  • Locked
  • Question
Hello, I need help with my query. I
Replies
2
Views
110
Magnolia1
Magnolia1

Part and Inventory Search

Sponsor

Back
Top