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
 
Back
Top