My tables lost their AutoNumber fields

[Bill Nicholson]

I ran an corrupted mdb through a third-party recovery utility and it
recovered the tables but it changed the AutoNumber fields to Longs, all 200
of them. Since the tables have data in them I can't simply change the field
type back to AutoNumber, at least not in the Access table designer. Any
thoughts?

Access 2000, by the way.


Thanks,

Bill
Cincinnati, OH USA

 

[Rick B]

I had a similar situation, and I created a new table and used an append
query to copy the records to it.

Rick B


I ran an corrupted mdb through a third-party recovery utility and it
recovered the tables but it changed the AutoNumber fields to Longs, all 200
of them. Since the tables have data in them I can't simply change the field
type back to AutoNumber, at least not in the Access table designer. Any
thoughts?

Access 2000, by the way.


Thanks,

Bill
Cincinnati, OH USA

 

[Rick Brandt]

I ran an corrupted mdb through a third-party recovery utility and it
recovered the tables but it changed the AutoNumber fields to Longs, all 200
of them. Since the tables have data in them I can't simply change the field
type back to AutoNumber, at least not in the Access table designer. Any
thoughts?

Access 2000, by the way.

Create new blank tables with the same structure (except with AutoNumber fields)
and then run append queries to push the data into the new tables. MAKE SURE you
include the existing long values in the append so the new table will retain
those values rather than assigning AutoNumber values to them.

You would of course have to rebuild all of your relationships with the new
tables.