When you say "It does not work" do you mean it throws an error or returns incorrect values?

The label being filled by the initialized integer displays a "0",
which I am assuming is the default value for an Integer that hasn't
been filled. Intellisense says that ExecuteScalar returns an object.

I'm thinking I have to somehow load  myCommand.ExecuteScalar into a
datareader or some other object  and read that. . . .

Hope this is enough info. Just want to add a record to an Access
database and get the Autonumber back. . . . .

Give us the SQL you are using....................

Ok, here is my code for my "LinkAdd" click. It does add a record. I'm
just trying to get back the record's autonumber at the same time I
append a row  (simplified for the purpose of illustration).
Pushing "F1" when my cursor is inside of ".ExecuteScalar" gives me
help which says: "Executes the query, and returns the first column  of
the first row in the resultset returned by the query. Extra columns
or rows are ignored." So, maybe it only works on Select queries, but
it DOES return  the first row and first column:

Private Sub LinkSave_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles LinkSave.Click
Dim myConnection As New OleDbConnection
(fConnectionString)

Dim strSQL As String = "INSERT INTO tblDances
(AdminID) VALUES(1)"
Dim myCommand As New OleDbCommand(strSQL,
myConnection)
myCommand.Connection.Open()
Dim intDanceID As Integer

intDanceID = CType(myCommand.ExecuteScalar(), Integer)

lblDanceID.Text = intDanceID-----Nothing happens here

myConnection.Close()

End Sub

You don't need to pass it to a datareader in fact the soulnt work, it
returns a value that can be cast to to string, int etc. For whatever reason
it is not getting a value. I'm not sure that Access can reurn the record id
in this way (always had to use addnew and then update to get the id in asp).
It does certainly work  with Ms Sql Server but I guess thats no help.

ExecuteNonQuery
ExecuteScalar("SELECT @@Identity")

I am skeptical because of round-robin and concurrency issues that this way is reliable but I am curious what SQL approach you are using.

keep in mind that ExecuteScalar returns 1 value, not the 1st row/column. Subtle difference.

I tried what you suggested, the .ExecuteNonQuery and then
the .ExecuteScalar("SELECT @@Identity FROM myTable") and it worked.
I'm with you in thinking that it sure seems clunky. Any better ways
are welcomed to replace this:

Dim myConnection As New OleDbConnection
(fConnectionString)

Dim strSQL As String = "INSERT INTO tblDances
(AdminID) VALUES(1)"
Dim myCommand As New OleDbCommand(strSQL,
myConnection)
myCommand.Connection.Open()

myCommand.ExecuteNonQuery()

strSQL = ""
strSQL = "SELECT @@Identity FROM tblDances"

Dim cmd As New OleDbCommand(strSQL, myConnection)

Dim intDanceID As Integer

intDanceID = CType(cmd.ExecuteScalar(), Integer)

lblDanceID.Text = intDanceID

myConnection.Close()

Utility Belt
www.learnasp.com/freebook/learn/utilitybelt.aspx