ID Number Change

  • Thread starter Thread starter needing help
  • Start date Start date
N

needing help

I deleted a couple rows when compiling my database. Now it goes from ID
number 1 to 6. How can I fix it and make it number 2 and go from there?
 
I'm assuming that you are talking about an autonumber field. In which case
for all practical purposes, you can't. Autonumbers are not guarenteed to be
sequential. There are many ways to 'burn' a number as you have seen.

If you need sequential numbers, you'll need to check what the highest saved
number is and add one. This must be done in a form as Access doesn't support
things like triggers and squences as do other DBMS such as Oracle.
 
Back
Top