Bringing Over a Table with an Autonumber

[nashat21]

Hi!

We recently converted to a new database. I managed to bring in all the data from the previous database with no major problems. However, I had one table "Project" that assigned a ProjectID automatically using the AutoNumber Data Type. Now that my Project data is in the new database, the ProjectID needs to be inputted manually. Is there any way that I can make it an automatic assignment? Autonumber reassigns all the ProjectIDs and that is not a feasible solution for us.

Any help will be greatly appreciated.

Thanks

Nashat

 

[Alexandre]

I believe you still can use an autonumber, and import your data into that table. The autonumber field will accept your ProjectIds whatever they are (assuming there are integers and without duplicate). It will then continue numbering from the highest Project ID

 

[Rich]

If you import all the tables and the relationships at the same time, Access will maintain the integrity of your data.