I am connecting a vb.Net app with an Access backend db. Each db record has a unique autonumber that is associated with it. How can I return the Row number that a specific autonumber exists at? Here is the code that I use to populate the dataset.
con.ConnectionString = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=c:\test.mdb;Jet OLEDB:Database Password=pass123;"
sql = "SELECT * FROM [Table Name]"
ds = New DataSet
da = New OleDb.OleDbDataAdapter(sql, con)