Hello programmers,
How do I reset an autonumber field on a table to 1 after I run a delete query for this temporary table without having to delete the field and recreating it on the table? I noticed that if I run the compact and repair utility it automatically resets it to 1. The only problem is that this becomes a problem in terms of automation.
Thanks,
Felix
How do I reset an autonumber field on a table to 1 after I run a delete query for this temporary table without having to delete the field and recreating it on the table? I noticed that if I run the compact and repair utility it automatically resets it to 1. The only problem is that this becomes a problem in terms of automation.
Thanks,
Felix