Autonumber delete

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been moving data from one Access database to another and in my
enthusiasm, attempted to move too much info at one time. As a result, the
autonumbering was altered - it skipped from 875 to 1074. Does this mean that
the database has lost valuable space as a result? Does deleting a record mean
deleting space?

Thank you for your time.
 
Hi,
It doesn't matter if the auto number isn't consecutive.
Your only concern should be if you have any foreign keys that relate
back to that particular auto number field.
 
Actually, deleting records doesn't immediately free up that space.
To recover that space, run Compact and Repair from the Tools - Database
Utilities menu.

HTH
- Turtle
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

values in the AutoNumber field are not sequential, why? 5
Primary Key Autonumber - Is it the best choice for discrete ID num 11
Add autonumber to a large table? 0
compacting database doesn't reset autonumber (ver 2000) 3
Autonumber records inserted in gaps 1
Autonumber Suggestion 2
Autonumber Field 2
record numbers 3

Back
Top