1.

Solve : Autonumber problem in Access database?

Answer»

I exported data from an Access DATABASE to Excel, manipulated the data, and then imported it into a modified version of the original Access database. The imported data contained the original autonumbers assigned to each record. When a new record was added, the AUTONUMBER assigned to the record wasn't the next consecutive number. It wasn't even close.

Can someone help. Let me know if you need more information. I may not have explained this problem very well.

Quote

and then imported it into a modified version of the original Access database

How did you MODIFY the database? UNLESS there is a relationship between the data and the autonumber there is no reason to reset it.

If you MUST reset the autonumber, you can try this.


Discussion

No Comment Found

Related InterviewSolutions