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.
 
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

Need Help soon with this querry!!!!!! PLZ PLZ 0
Query to create multipe total fields 7
quick query question 3
ID numbers in Access records. 1
How to subtract a number from a Mergefield? 0
Mobo name and id change 2
Counting multiple memberships 1
Rank and row number in Access? 3

Back
Top