FP writing to Access - need autonumber value

[webage]

I'm writing FrontPage form results to a Access database on my website
that is autonumbering the ID column for each record written.

What's an easy way to get that ID number back to the user's screen
after they submit the form ? If I could figure out how to get the
timestamp from the submission and check against it to retreive the
associated record I'd be very happy.

Any advice ?

Thanks,

Mike

 

[Bob Evans]

After the record has been added, execute the following query:

SELECT @@IDENTITY;

This is covered in the following knowledgebase article:

http://support.microsoft.com/kb/232144/EN-US/

Bob