Create a AutoNumber primary key in your table using code.

This post will discuss how to create a AutoNumber primary key using VBA code. ... A while back I wrote a post on using temp tables in your code and I mentioned using Alter table statements to modify your temp tables on the fly.

accessexperts.com