I'm having trouble and just getting started with ADO. I've been using DAO.
In this code:
sqlStr = "select * from photos where bookmark='" & item_number & "'"
myRecSet.Open sqlStr, MyConnObj, adOpenKeyset
I'm just trying to see if a record exists in a table. It is very slow and the query ends up timing out. My approach must be wrong. Any ideas?