Access DB with Autonumber Field

[ABinBoston]

I am running an InterDev application that links to a MS Access 2k database. If I add a new record, the autonumber field does not show. If I view the data in a grid view after adding a record, the grid does show the autonumber. How can I get the autonumber to appear in detail view after saving the record?

Thanks - Anthony
abinboston@aol.com

 

[MerlinB]

Never a particularly easy one this! Some databases make it a bit easier though (SQLServer has the @@identity value).

If there is something unique in the data being inserted, then you can issue another SELECT to re-fetch the data just inserted - construct a WHERE cluse to include all of the columns that make up the unique value. Of course, if the auto number is the only unique thing then you have a problem!

On other databases, you may write a stored procedure to perform the INSERT. The procedure would return the auto-number value back. I am not sure if you can 'call' VBA functions in your Access database via ASP code / ODBC - if you could then this could probably achieve the desired result.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)