Seeing the actual SQL string made dealing with the question so much easier for those of us that do have that experience.
This is a great illustration of where following the guidance in How to Debug SQL String really comes into its own. In your situation I suspect you've left this out already, which would be perfectly correct. This is why the Help System covers that possibility.
It is often critical that the original ID is perpetuated when a record is brought back. However, consider the situation where you want to back up your data - either to a separate table ( :-( ) or a separate database. Generally speaking, even when copying records, you would still want new records to be assigned an identity automatically. Ths one, using the SELECT caluse, is designed for copying records from one table to another. The one you should probably be using is with the VALUES() clause. There are two variations of the syntax for INSERT INTO. (I'm not sure what that means: There wouldn't be an original number for a record that I'm just adding). Do include the AutoNumber field in the query if you want to retain the original values from the field.". The Access Help () says "If you append records to a table with an AutoNumber field and you want to renumber the appended records, do not include the AutoNumber field in your query.