How to get the value of counter field

[fniles]

I am using VB.NET 2005 and Access database.
In the database I have table (myTbl) with a column called ID as a primary
key, and it is a counter field.
When I insert into myTbl, how can I get the value of ID ?

Private m_cmd As OleDb.OleDbCommand

m_cmd = New OleDb.OleDbCommand
sSQL = "insert into myTbl (col1,col2) VALUES (?,?)"
m_cmd.Parameters.Add("@col1", OleDb.OleDbType.VarChar, 50, "col1")
m_cmd.Parameters.Add("@col2", OleDb.OleDbType.VarChar, 50, "col2")
m_cmd.Parameters("@col1").Value = sParameterValue1
m_cmd.Parameters("@col2").Value = sParameterValue2
With m_cmd
.Connection = adoConOLE
.CommandText = sSQL
End With
m_cmd.ExecuteNonQuery()

How can I get the value of the column ID ?
m_cmd.Parameters.Add("@ID" & sParameterName, OleDb.OleDbType.BigInt, 4,
"ID").Direction = ParameterDirection.Output '--Can I do this, and if I
can, is the following sql statement correct ?
insert into myTbl (col1,col2) VALUES (?,?)
Thank you.

[Stephen Howe]

This is most certainly possible in Access, and from a bit of googling

you'll come up with hits that may include this one describing how to do
it:
http://msdn2.microsoft.com/en-us/lib...t0(VS.80).aspx

Why are you posting to microsoft.public.data.ado ?
IT IS NOT A .NET NEWSGROUP, it is for ADO, not ADO.NET

I am sick and tired of clueless .NET programmers continually posting to
microsoft.public.data.ado.
Microsoft created hundreds of .NET newsgroups, all with "dotnet" somewhere
in the newsgroup name.
If a newsgroup does not have "dotnet" in the name it is not a .NET
newsgroup.

If you cant distinguish newsgroups you should abandon progarmming, you are
not up to it.

Stephen Howe