Db built, tested, how do I get rid of test data / restart autonumb

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that I built and I want to start using it, I'v tested it
with dummy data. How do I remove all the dummy data and restart the
autonumbers from naught? Is there away of just copying a database without
data? I don't want to just leave the dummy data there until I have real data
to over-write the dummy data with.
 
Stephen,
You can delete the data from the tables, but your AutoNumbers will not reset
to zero. However, if you create a new database and import your tables as
structure only (and copy everything else), you will get a new database and
your autonumbers will reset.
 
Delete the records in the table and compact the DB. That will start the
autonumber over again
 
Back
Top