bdj,
Since I don't know what all you have been through, please forgive me if my comments include approaches you have already tried.
Well, on 2nd though, take a look at the mdb in Access97 I have attached. I don't see the loss of record 2 and there are 50 records both in this dB and in the...