I am writing a program that uses ODBC to connect to a quite large database on a server. Since it is in a multiuser environment I use BeginTrans, CommitTrans and RollBack to keep network traffic down. The problem is that the recordset.nomatch is true sometimes even though the field I am searching for exists. I use findfirst to search in the recordset. I tried to search for the same field in a for...next loop and sometimes it fails.
What is the problem?
Any suggestions on how to work around the problem?
I am using VB 4.0 32-bit and 32-bit ODBC-drivers.



------------------
/Magnus