Unanswered: MS Access 2000 serial primary next value
I have table with serial primary key (counter or autonumber field).
How to wright SQL-query for MS Access DB, wich get next value of key field
(next counter value of new table record)? Functions max and dmax don't give right
1. table: user
- user_id (key field) -- user_name --
3rd and 4th record were deleted.
Next counter value is 5.
2. table user - new empty table (no operations were maked with this table)
Next counter value is 1