I have a table in Access 97, this table have an Autoincrement field, i need to get the number of the next Increment. E.G. I have 3 rows in my table, so when i put one more row, it´ll receive number 4 in the database. I need the next value before inserting new data to the table, or after i´ve inserted the data.
I need to get from the access this Number, i´ll apreciate any help ;)