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

Elam, Debbie DElam at jenkens.com
Wed Jan 29 12:09:01 CST 2003


Erase the record again and put it in with a query.  If you use the query to
add the record, it will enable you to get the same autonumber in there.

Debbie

-----Original Message-----
From: William Hindman [mailto:dejpolsys at hotmail.com]
Sent: Wednesday, January 29, 2003 11:56 AM
To: accessd at databaseadvisors.com
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


- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject
to the Attorney-Client Privilege, (2) an attorney work product, or (3)
strictly confidential. If you are not the intended recipient of this
message, you may not disclose, print, copy or disseminate this information.
If you have received this in error, please reply and notify the sender
(only) and delete the message. Unauthorized interception of this e-mail is a
violation of federal criminal law.

  This communication does not reflect an intention by the sender or the
sender's client or principal to conduct a transaction or make any agreement
by electronic means.  Nothing contained in this message or in any attachment
shall satisfy the requirements for a writing, and nothing contained herein
shall constitute a contract or electronic signature under the Electronic
Signatures in Global and National Commerce Act, any version of the Uniform
Electronic Transactions Act or any other statute governing electronic
transactions.





More information about the AccessD mailing list