[RESOLVED] Finding out an Autonumber

[aaronskw]

I've got a php script that does a simple insert into an MS Access table that has a field 'SpecID' set as an Autonumber.

Is there a way of getting the SpecID number either before or after the new record is created?

Thanks

[visualAd]

Are you using odbc?

[aaronskw]

Thanks for the reply, Yes I am.

[visualAd]

At the very least, you'll need to execute another query:

http://www.utteraccess.com/forums/sh...086320&fpart=1

Using standard complient SQL, you can:

SELECT MAX(id) AS last_id FROM table_name;

[aaronskw]

I'll give this a go and see what happens.

Thanks

[aaronskw]

This works great for my purpose.

I extended it a little as more than one user will be updating:

SELECT MAX(id) AS last_id FROM table_name where userid = $UserID;