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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AutoNumber

Status
Not open for further replies.
dvannoy

dvannoy

MIS
Joined
May 4, 2001
Messages
2,765
Location
US
I have a field that I set to a uniqueidentifier...How can i make that field auto count like a autonumber in access??

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com
 
Sort by date Sort by votes
You want to set that fields Identity to 'Yes'. Identity Seed tells it where to start and Identity Increment tells it how many to go for each record.
 
Upvote 0 Downvote
The Identity field is grayed out... DVannoy
A+,Network+,CNA
dvannoy@onyxes.com
 
Upvote 0 Downvote
Try changing the type to Int....
 
Upvote 0 Downvote
Sorry got it..it had to be set as an INT..

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Penny001
  • Locked
  • Question Question
Autonumber column
Replies
2
Views
149
Penny001
Penny001
tbpowers
  • Locked
  • Question Question
Autonumber Column
Replies
1
Views
79
MDXer
MDXer
mattm31
  • Locked
  • Question Question
Add new Column with Autonumber
Replies
2
Views
140
gmmastros
gmmastros
johnc83
  • Locked
  • Question Question
Prefix to autonumber
Replies
2
Views
109
johnc83
johnc83
cesqueda
  • Locked
  • Question Question
AutoNumber on SQL table; not created until table is saved???
Replies
2
Views
100
LNBruno
LNBruno

Part and Inventory Search

Sponsor

Back
Top