Products being used: Access 2000, .adp file for front end forms and reports; SQL Server 2000 for all the "backend" stuff, like tables stored procedures, etc.
I have completed building and testing a database that will be used in production Oct 1st (next Friday). I need to delete all of the testing and training data that currently exists in the two main tables, both of which have auto-number identity fields. The deleting of the data is not the problem...how to reset the identity fields to zero is.
Does anyone know if this is possible? I don't want to change the structure of the tables (i.e. delete the two auto-number fields, and then recreate them) unless absolutely necessary. What I'm looking for is some "magic" command that "resets" the auto-number to zero.
Thanks for any suggestions.
--Telephony Tech
I have completed building and testing a database that will be used in production Oct 1st (next Friday). I need to delete all of the testing and training data that currently exists in the two main tables, both of which have auto-number identity fields. The deleting of the data is not the problem...how to reset the identity fields to zero is.
Does anyone know if this is possible? I don't want to change the structure of the tables (i.e. delete the two auto-number fields, and then recreate them) unless absolutely necessary. What I'm looking for is some "magic" command that "resets" the auto-number to zero.
Thanks for any suggestions.
--Telephony Tech