AutoNumber beginning with #1 after an Import Query

M

Matt

I have a table that I update frequently. I run a Delete Query which deletes
all records in the table. Then I import raw data from an Excel file into this
table. The table conatins an AutoNumber as the Primary Key. When the data
is imported the AutoNumber does not begin with 1, it will begin with the
highest number of records that the table had before Delete. An example would
be my table conatins 100 records, I delete them and then import. My
AutoNumber will beging at 100 and end at 200. I am scared the number will
increase to high after repeating these steps over and over again. Should I
be worried?

Thanks,
Matt
 
J

John Vinson

I have a table that I update frequently. I run a Delete Query which deletes
all records in the table. Then I import raw data from an Excel file into this
table. The table conatins an AutoNumber as the Primary Key. When the data
is imported the AutoNumber does not begin with 1, it will begin with the
highest number of records that the table had before Delete. An example would
be my table conatins 100 records, I delete them and then import. My
AutoNumber will beging at 100 and end at 200. I am scared the number will
increase to high after repeating these steps over and over again. Should I
be worried?
Click to expand...

The number will increment to 2147483647, then roll over to
-2147483648, and start counting up to zero. That gives you some 43
million imports before you run out of autonumbers; I suspect Access
will have been superseded by something even more powerful by then!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top