Problem converting db from Access 95 to 2003- Auto Numbered field

[Guest]

With the help of others I have converted an existing Access 95 database to
2003 but found that 2 tables had problems where auto numbered fields had been
changed to just number fields during the conversion. I am trying to get the
numbers in the 2 fields to be the same as the stored copy of the Access 95
database unsuccessfully. I successfully added auto number fields back to the
converted tables but they begin numbering at 1 instead of using the existing
data from my Access 95 database tables. Can you offer any guidance?
PS - I know I should avoid auto numbered fields in the future, but I did not
create this database and I have to fix it soon.

 

[Guest]

Hi NoviceUserAGB,

Don't avoid autonumber fields, they are essential for Primary Keys. To fix
your problem, leave your "original" number fields there and let Access create
your Autonumber fields again. Then, update any tables where the original
number was a foreign key back to your main table, setting the foreign key
value to the new Autonumber field where.

Hope this points you in the right direction.

Damian.