I am having a problem with a linked table to a MS SQL 7 database.

The table I am using has an autonumber field as primary key. After entering a new record, the record disappears - if you navigate to record number "215" you find the record has really been added..just adjusted to record number 215. Open and close the table and it reappears in it's correct place.

I have seen messages on the net from other people with same mysterious "record 215" problem - but no answer. The messages that I have read from other people say the problem rears it's head after you have added 215 records. I couldn't find an answer to the problem anywhere - only others that were having the same problem.

Anyone with a clue?


PS I tried pulling the table down to access and then importing back into sql but that didn't help.