Using FindFirst in Access VBA with GUID

[dmr]

I am successfully using the following code to
search by GUID. Are their any special coditions
I should be aware of ?

Adapted from Carol Chipman posting
By Douglas M. Reisman

DBGuidFld = Forms!frmMerge.RecordsetClone.PlacementData4
strGUID = StringFromGUID(RecOld.Fields(DBGuidFld))

RecNew.FindFirst "StringFromGUID(" & DBGuidFld & ") = " & strGUID
If Not RecNew.NoMatch Then
' Use Update method, Record Found
else
' Use Append method, Record not found
End If

[dmr]

I forgot to mention its an ODBC connection

dmrg...@diac.com (dmr) wrote in message news:<ecfd9464.02050...@posting.google.com>...

[dafr...@gmail.com]

This works! 14 years later....
http://blog.dafran.ca/post/2016/03/29/Using-FindFirst-in-Access-VBA-with-GUID.aspx

[Phillip]

The issue with this approach is that while you will usually have an index on the GUID field, the index cannot be used. Because of the function call in the expression the engine will most likely have to do a full table scan.