[AccessD] Autonumber Corruption ...Help!!!!

1.  Copy the table including data to a tmp name, 
2.  delete the existing table, 
3.  compact and repair, 
4.  append the tmp table to the original table (including the ID)
5.  Voila!!! you are saved.

6.  Now don't do that again.

Tom



----- Original Message ----- 
From: "William Hindman" <dejpolsys at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, January 29, 2003 11:55 AM
Subject: [AccessD] Autonumber Corruption ...Help!!!!


> ...I did something really stupid ...not enough sleep I guess :(
> 
> ...tblCompany.CompID is an Autonumber PK in a be mdb
> 
> ...one of clients computers disconnected suddenly and corrupted the mdb
> 
> ...an entire record in tblCompany was corrupted and repair did not fix it 
> ...so I went to an archive from December and copied the record and pasted it 
> into the current table ...all fine except that the AN PK had now changed and 
> would not let me replace it with the original :(
> 
> ...so I got stupid and went into design mode and changed the type from AN to 
> a long ...fixed the PK ...then tried to change the data type back ...and of 
> course it won't let me :(((((
> 
> ...the company owner has last night's server backup tape but is in Miami and 
> no one can reach him :(((((
> 
> ...is there any way on god's green earth I can repair this?
> 
> William ...doofus extraordinaire :((((
> 
> 
> 
> 
> 
> 
> _________________________________________________________________
> Add photos to your messages with MSN 8. Get 2 months FREE*.  
> http://join.msn.com/?page=features/featuredemail
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd