insert record in Ms Access database AND retrieve the autonumber (ID)

[nicholas]

I would like to insert a new record in a Ms Access database and retrieve the
newly created ID (autonumber).

I would like to do it in VB.NET for an ASP.NET page. ( no asp)

I found several examples on the net, but most of them just work with
sql-server (@@indentity), or use just asp with includes etc.

Hope someone can help me with a 'working' example...

THX

 

[Greg Burns]

FYI, this only supported with Jet 4 (which means Access 2000 or better).

Sorry, I don't have an example on hand...

Greg

 

[nicholas]

sorry to ask this, but what's FYI ?

THX

FYI, this only supported with Jet 4 (which means Access 2000 or better).

Sorry, I don't have an example on hand...

Greg

 

[nicholas]

ok, got it (for your info)...
;-)

sorry to ask this, but what's FYI ?

THX

 

[Leah]

I usually store an 'entered by' column, and with ms access, you can
get the max id where the entered by is the current logged on user.

Hope this helps