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!

Random AutoNumber

Status
Not open for further replies.
jwilso

jwilso

Programmer
Jun 29, 2004
4
US
I created a design master and replica, during its creation the wizard apparently changed all of the AutoNumber Fields from incremental to random. Access will not allow you to change the field back to incremental. I am wondering if there is a way to change the field back to incremental without deleteting the field and starting over. Thanks
 
Sort by date Sort by votes
Random AutoNumber is MANDATORY for replica.
Feel free to play with the F1 key.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Using old IDs as Autonumbers 1
Replies
6
Views
464
Andrzejek
Andrzejek
MrMode
  • Locked
  • Question
Table locked after inserting a record with autonumber field value
Replies
2
Views
126
MrMode
MrMode
puforee
  • Locked
  • Question
Emergency...Autonumber field repeating when ne record is added...Error messages
Replies
1
Views
92
puforee
puforee
BoulderRidge
  • Locked
  • Question
AutoNumber field AND unique index field contain a duplicate value in my table
Replies
5
Views
132
BoulderRidge
BoulderRidge
ColdDay
  • Locked
  • Question
Benefit of using an AutoNumber field.
Replies
5
Views
118
BNPMike
BNPMike

Part and Inventory Search

Sponsor

Back
Top