Problem with primary key on imported database

[1953hogan]

Hello,



I am teaching myself Access after years of working with Lotus Approach. I am creating a Customer database in access after importing tables from Approach. I have a table called "Customers" that had existing data and have set the primary key to "customerID" which is the same field that was used in Approach.

This customerID field needs to auto number and increment by 1 each time a new customer record is entered, but when I try to change the field to autonumber, I get this message: "Once you enter data in a table, you can't change the data type of any field to autoNumber..."

I really don't want to recreate thousands of customer records because the customerID is used in relationships with other tables as well.

How can I use my existing ID field and get it to autonumber when a new record is added?

Thanks very much,

Steve

[TheShabz]

I dont think you can. You would probably fake an autonum field by setting the default value to DMax(fieldname As String, TableName As String) +1

Not 100% sure though.