I am using seqno field in access(with jdbc),which uses AutoNumber as datatype.and Which increments itself if i add any new record.
The problem is with my deletion of record,if i delete some records,there so no changes in seqno because it just increments itself.
But i want seqno should also update itself,if i delete any records.can anybody tell me wht i should do to solve this problem.