Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS ACCESS: REPLACING A DELETED RECORD

Status
Not open for further replies.
GOLF72

GOLF72

Vendor
Apr 28, 2003
1
0
0
US
I HAVE AN ACCESS DB FOR MY SPARE PARTS. THE FIRST COLUMN IS SET TO AUTONUMBER. OVER TIME, I HAVE ACCIDENTALLY DELETED DUPLICATE RECORDS, WHICH ALSO REMOVES THE SEQUENTIAL AUTONUMBER. CAN THE NUMBER BE REPLACED? IF SO, HOW?

THANX
 
Sort by date Sort by votes
In all that I have read the only way to reset an auto number is to delete all the data from the table, then run "Compact and Repair Database" from the "Tools, Database Utilities" menu.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Snirt
  • Locked
  • Question
MS-Office 2013 Excel Issue
Replies
1
Views
104
SkipVought
S
techie131
  • Locked
  • Question
MS Access Query
Replies
2
Views
50
techie131
techie131
pmover
  • Locked
  • Question
MS Mac Office Single User License
Replies
3
Views
93
pmover
pmover
pendle666
  • Locked
  • Question
Excel - Quick Access Toolbar - customise with a drop-down menu
Replies
3
Views
87
combo
combo
N1GHTEYES
  • Question
Count areas within a range 1
Replies
14
Views
547
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top