My tables lost their AutoNumber fields

  • Thread starter Thread starter Bill Nicholson
  • Start date Start date
B

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
 
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
 
Bill Nicholson said:
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.
Click to expand...

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.
 
Back
Top