Dear Sir/Madam


In my access table which was created earlier the Autonumber was structred as Random not as Increment.

But no although the table has 19 records when new record is being added then
the Autonumber field shows some number in 10 Lakhs and data Overflow error comes.

When I try to change it to Increment it says that it can't be changed due to some relationship , there are data present bu not in squence etc...


Please Advise