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
result. Examples:

1. table: user
- user_id (key field) -- user_name --
1 John
2 Jack
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