I understand that using SEEK is better than using .FIND when finding a record in a table since .FIND reads the records in the table in sequential order. But SEEK requires an index.
If I want to use SEEK then how will I connect to the database and open Tables with its corresponding INDEX? And how will I perform the SEEK command?
I use the following commands to connect to the database and open the table whenever I want to perform a .FIND
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Persist Security Info=False;" & " Data Source=" & CheckPath(db_NAME)
Adodc1.RecordSource = "SELECT * FROM VenueTable ORDER BY VenueName"
.FIND search criteria
What is the equivalent in using the SEEK command?