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 there is some record deleted then this will not work correctly
for instance i have records
id S_N
11 a
23 b
31 c
45 d...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.