The LastAutoIncValue property indicates the last auto-increment value used for the table. This read-only property can be examined to determine what value will be assigned to the next auto-increment field when a record is appended to the table.
This property is read-only, you must alter the structure of a table in order to change it. Also, this property does not require that the table be open in order to return a value. This allows the the property to be examined without opening the table.