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

Just guessing here, but consider any indexes too -- if you delete the
AutoNumber and another index takes over, the records won't be in the
AutoNumber order.

Susan H.


> 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
>
>