Re-set primary key autonumber

S

SR

Registered User.
Local time
Today, 18:40
Joined
May 1, 2001
Messages
14
My shiny new database is ready to go - now I have deleted all my trial data and want to re-set the autonumber primary key of my main table to start at "1" (I thought I could delete it and re-insert it but it won't let me). Suggestions?
 
Compact the database. If the tables are empty, the autonumbers will be reset.
 
You must log in or register to reply here.

Similar threads

R
Solved Import Excel file into existing table with an autonumber primary key field
Replies
6
Views
515
Isaac
Isaac
Papa_Bear1
Form seems to have table locked even after closing.
2
Replies
27
Views
671
Gasman
Gasman
brucemc777
Solved Take three user selected fields and use an INSERT INTO statement to create a new record in a table that only has those three field AND a Key
Replies
11
Views
727
Pat Hartman
P
C
Join key of '***' not in recordset
Replies
9
Views
347
ChrisLeicester
C
B
When a bound form is opened, I need to change, via vba, the autonumber/primary key field from "(New)" to an actual new autonumber
Replies
11
Views
641
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom