Start with clean tables

[Sandra Grawunder]

I have been setting up a simple database and now I know
that everything is working OK, I would like to clean up
the tables so that the PK numbers start out fresh. My
tables are all empty and I have removed all the
relationships. I have deleted the primary key fields in
the table, saved the table design, then went back in and
recreated my PK's. When I tested this, the PK's are
starting where they left off, rather than at 1. How do I
start out with new PK's in the tables?

Thanks,

Sandra G

 

[Allen Browne]

Compact the database:
Tools | Database Utilities | Compact

If that does not work, you need to apply a JET 4 service pack. Available
from Downloads at support.microsoft.com