If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
My tables lost their AutoNumber fields
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 |
#2
|
|||
|
|||
My tables lost their AutoNumber fields
I had a similar situation, and I created a new table and used an append
query to copy the records to it. Rick B "Bill Nicholson" wrote in message ... 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 |
#3
|
|||
|
|||
My tables lost their AutoNumber fields
"Bill Nicholson" wrote in message
... 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. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lost text fields in merge | CGiannini | General Discussion | 5 | June 4th, 2004 10:23 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
Using Form Fields in tables | HitParader | New Users | 3 | May 27th, 2004 12:38 AM |
linking tables with unmatched fields | tachia | Database Design | 1 | April 30th, 2004 03:53 PM |
Calculating fields in my tables (Word XP) | Jessica M. | Formatting Long Documents | 5 | April 28th, 2004 03:14 PM |