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 strongm 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
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
146
SkipVought
S
techie131
  • Locked
  • Question
MS Access Query
Replies
2
Views
85
techie131
techie131
pmover
  • Locked
  • Question
MS Mac Office Single User License
Replies
3
Views
182
pmover
pmover
pendle666
  • Locked
  • Question
Excel - Quick Access Toolbar - customise with a drop-down menu
Replies
3
Views
187
combo
combo
N1GHTEYES
  • Locked
  • Question
Count areas within a range 1
Replies
14
Views
721
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top