with autonumber'd primary key--any way to reinsert an old record

[DigitalVinyl]

We lost some records on a corruption. The main, big table lost a few
records. The primary key is an autonumber. Any way to reinsert the old
ones? (btw,Access 2003) SO far I'm thinking no.

Is it beneficial to have non-autonubmer'd key--could I reconstruct old
records then?

Also is there any performance issues with table sizes (number of
fields, or num of records)in Access mdbs. We have a front end on each
PC and a back end on the server. 6-7 multi-users. Back end is now
12Mbs(it was 6Mb before converting from Access97 two weeks ago). The
main table is rather large, several dozen fields, 9016 records.


DiGiTAL_ViNYL (no email)

 

[Tim Ferguson]

Any way to reinsert the old
ones? (btw,Access 2003) SO far I'm thinking no.

Yes: you can specify the number for the autonumber field with an append
query:

INSERT INTO MyTable (ANCounter, FullName, BirthDate)
VALUES(33, "Eric van Stridow", #1956-09-30#)

as long as there is no record 33 already.

Hope that helps


Tim F

 

[Jeff Boyce]

To add to Tim's response, also be VERY VERY certain that the new
(replacement) ID=33 that you insert is the same record that any "child"
tables refer to with that ID# as a foreign key.

Good luck

Jeff Boyce
<Access MVP>