[AccessD] Autonumber Corruption ...Solved :)

...mucho gracias to Tom, Debbie, and Susan :)

...AccessD to the rescue ...talk about getting this list back just in time 
...I'm so freaking happy I'm going over to www.databaseadvisors.com and make 
a PayPal contribution ...:)

...btw, I got Tom's reply first and it worked perfectly ...it was the query 
approach that I didn't think of :))))

William ...sssshhhhh!!!! ...I still feel like a doofus but I look like a 
hero to the client!!!!!! ...don't tell him :)))))






>From: "Tom Adams" <tomadatn at bellsouth.net>
>Reply-To: accessd at databaseadvisors.com
>To: <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Autonumber Corruption ...Help!!!!
>Date: Wed, 29 Jan 2003 12:09:18 -0600
>
>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
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd


_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus