Jump to content
  • 0

Override Autonumber?


SeanConrad
 Share

Question

I recently took over a database and have found that a few records were incorrectly deleted. I want to reenter these records into the table using the original ID#. However, this datatype is set to autonumber and will not let me enter the previous ID number. There is data in the system tied to this ID but no ID to match to. I could assign a new ID but then I would have to go through and edit 14 years worth of records. What are my options? I want the original ID if possible.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

What you can try on this one is, try converting the data type of the field from autonumber to integer. From after that, add the new records with your intended ID for them (Make sure that they are still unique). After that, convert the value to autonumber again. 

Try this on the test table first and make sure you have a backup of the tables before you proceed. Just incase that it wont work. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...