Primary Key - ID numbers changed!

[Renee]

Hi,
I have ID Number as my primary key in my table and I made
the following changes to the table last week. I added
a "case name" field and deleted two fields that weren't
useful. I also changed the field name to a couple of the
fields. In the form for the patient table I re-arranged
how it looked. My major problem right now is that all of
the ID numbers, which I have set as the primary key are
different from how they were before. How do I get them
back to what they were because all of our files are bar
coded to reflect the old ID numbers. Help!

 

[John Vinson]

Hi,
I have ID Number as my primary key in my table and I made
the following changes to the table last week. I added
a "case name" field and deleted two fields that weren't
useful. I also changed the field name to a couple of the
fields. In the form for the patient table I re-arranged
how it looked. My major problem right now is that all of
the ID numbers, which I have set as the primary key are
different from how they were before. How do I get them
back to what they were because all of our files are bar
coded to reflect the old ID numbers. Help!

Are you CERTAIN that the data in the field has changed? Or has the
table just been presented in a different sort order? What's the
datatype of ID Number? Autonumber, or something else? None of the
actions you describe should affect the value of data in existing
fields.

If it *did* change, for some unaccountable reason, you may need to go
back to a backup - note that before making major changes to table
structure you should ALWAYS make and test a backup of your database; I
hope you did so... :-{(