How is an Autonumber (Incremental Number) assigned to a field when using a Make Table query.
L Ladybird Jun 1, 2005 #1 How is an Autonumber (Incremental Number) assigned to a field when using a Make Table query.
A Allen Browne Jun 1, 2005 #2 Create the empty table ahead of time, and populate it with an Append query. If this is a temp table that you are needing to repopulate regularly, you can empty it out first with: dbEngine(0)(0).Execute "DELETE FROM [Table1];", dbFailOnError
Create the empty table ahead of time, and populate it with an Append query. If this is a temp table that you are needing to repopulate regularly, you can empty it out first with: dbEngine(0)(0).Execute "DELETE FROM [Table1];", dbFailOnError
