[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