The easiest way is to insert a unique value into the table along with the
record your storing, and then do a select to get the ID based on that unique
value as the where part of the query. DataTime TickCount is normally a
suitable value.
Its two calls as opposed to one, but its a very easy to implement solution.
--
Regards
John Timney
ASP.NET MVP
"denis" <de***@discussions.microsoft.com> wrote in message
news:F1**********************************@microsof t.com...
hello guys
I'm a novice for Asp.net, since now I've always used asp
I need to insert a record in an access database and get the last id of an
autonumber field
Can you please help me?
thanks