old database using new ID

[amerifax]

I have several visual dBase tables converted over to Access 2013. The old tables use identification, SEQ. I have retained the old SEQ , but now have the Access ID. It seems I somewhere saw that if you delete an ID, you will be changing all the subsequent IDs that follow. In other words, if you have ten records that have IDs of 1-10 , and delete record five, ID 005, record ID 006 now becomes 005.

Is that true. Is it a good policy to count on the ID number when you at times delete records?

True, I could test this theory myself, but I'm concerned that there might be conditions where it could be troublesome.

Bob

 

[pbaldy]

Have you tested? Deleting a record should not affect other records.

 

[amerifax]

>>True, I could test this theory myself, but I'm concerned that there might be conditions where it could be troublesome<<

The test did show favorable results. my concern was under certain conditions, it might not favorable. Also, somewhere in the past. I thought I had read an article in regards to my concern. That is why I posted a question.
Bob