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

Max autonumber

Status
Not open for further replies.
muppet123

muppet123

Technical User
May 11, 2005
19
GB
Hi,

Is it possible to prevent data entry by for example using the autonumber field and when it reaches a given maximum number further entries would not be possible?

TIA
Mup'
 
Sort by date Sort by votes
You can set a constraint on the field not to accept values higher than a specific value in the field properties.
The actual limitations of an autonumber field are for the same as a Long integer.

John
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Using old IDs as Autonumbers 1
Replies
6
Views
255
Andrzejek
Andrzejek
MrMode
  • Locked
  • Question
Table locked after inserting a record with autonumber field value
Replies
2
Views
77
MrMode
MrMode
puforee
  • Locked
  • Question
Emergency...Autonumber field repeating when ne record is added...Error messages
Replies
1
Views
57
puforee
puforee
BoulderRidge
  • Locked
  • Question
AutoNumber field AND unique index field contain a duplicate value in my table
Replies
5
Views
86
BoulderRidge
BoulderRidge
Moss100
  • Locked
  • Question
Maximum number of tables in Access 2003
Replies
4
Views
55
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top