How do I reset the primary key which is a automatic number in a t

[Guest]

 

[Joseph Meehan]

If you are smart, you don't.

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.

Using autonumber will just cause you frustration.

 

[Allen Browne]

After deleting the test records, compact the database:
Tools | Database Utilities | Compact

If this does not do the trick, and you are using Access 2000, you need the
service packs for Office 2000 and for JET 4. Both are available from
support.microsoft.com, in the Downloads section.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

news:[email protected]...