Numbering without "Auto-Number"

[Mksmall]

Is it possible to make Access sequentially number new records inputed to a database thru a form without using auto-number. I have an AS400 database that I want to convert to Access. There are over 38,000 records with a unique contact number, but Access will not let me change the data type of this field to auto-number since there are already numbers there. Access wants to start at 1. Any help would be appreciated.

 

[JumpinJimRivers]

the only alternative i found to autonumber for incrementing a number is this placed in an event procedure

Dmax("[field]","

","[criteria]"]

 

[JumpinJimRivers]

sorry, i mean

Dmax("[field]","

","[criteria]&quot+1

 

[pedro1]

You can either import the id field into the autonumber, or, you may need to import 1 record with the ID number you wish to start with and it will then increment from there. I've found ways around this issue in the past and there was something in the Access help file.

Ken

 

[B827]

this article in the ms knowledge base might help

ACC2000: How to Use an Append Query to Set Initial Value of an AutoNumber Field (Q209696)

 

[Mksmall]

Thanks Jump

That was the easiest and it worked!