In database AutoIncrease column. What if value reached maximum value

Question

I am developing an Access database application. This app have huge amount of changes (Added rows) every minute. All changes saved in a table which has an 'ID' Auto increase column (Starts from 0 ). At some point the 'ID' value will reach max. allowed value (Integer.MaxValue I think or whatever). how can I add new rows after this?

Note: When Adding rows I also remove previous rows. So, the total table rows count won't be greater than 100 rows, but 'ID' column won't repeat its values or restart counting from 0 again.

Even with a regular 32bit Autonumber column, it would last 2^31 / (60*24*365) = **4085 years** with one record per minute. :) — Andre, Dec 13 '18 at 11:10

score 2 · Answer 1 · answered Dec 13 '18 at 09:40

2

You have to perform a identity reseed. This link will explain how to do that in access db.

answered Dec 13 '18 at 09:40

cdev

5,043
2
33
32

Thank you very much, helpful. – Askcomp eugi-tech Dec 13 '18 at 11:08

score 1 · Accepted Answer · answered Dec 13 '18 at 10:10

1

Use a Large Number (bigint) instead and Stop Worrying About Exhausting Bigints.

answered Dec 13 '18 at 10:10

viking_grll

131
8

1

This is valid only for Access 2016 (Office 365). This is clear on the linked page, but it is best to include this information with the SO answer. The page also does not mention AutoNumber fields. I don't have Access 2016, so can you verify this solution works with AutoNumber? – C Perkins Dec 14 '18 at 02:19

In database AutoIncrease column. What if value reached maximum value

2 Answers2