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 - 16 Jan 2005 04:29 GMT
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

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>I have been setting up a simple database and now I know
> that everything is working OK, I would like to clean up
[quoted text clipped - 9 lines]
>
> Sandra G