What Can We Do If We Have To Get The Next Autonumber To Be Inserted In MS Access

what can we do if we have to get the next autonumber to be inserted {before inserting the record} in MS access


It is a simple think to get the max(id) + 1.But if tere is some record deleted then this will not work correctly

for instance i have records

id Employeename

11 a


23 b


31 c

45 d




then if delete 31 and 45 my record becomes



id Employeename

11 a


23 b






now when i get max(id) +1 it will return 24 {rather then 46 which i want's to retrieve}

Is there any way that i can get the next autonumber to be inserted prior to insertion of the record ?






{Although it is questions is not particular to sql server but i think some geek might answer it here}