I'm looking for the fastest way to update a table boolean field in an access table by way of VBA. A snipet of my code is below
For Each vFile In dictClipsDB.Keys
If Not dictFilesFound.Exists(vFile) Then
strSql = "UPDATE tblClips SET blnAlive = FALSE WHERE fldLocation = " &...
