Note: only certain kinds of queries can change (or set) values in a table.
Update queries are the most likely suspects followed by Append and MakeTable
queries. Update Queries appear in the database window with a + icon. If you
only have a few queries showing this icon, reviewing them manually may be
easiest/quickest.
A non- code solution:
Use the Documenter (Tools>Analyze>Documenter). Select all queries (or just
all Update queries). Under options make sure "SQL" is selected (you can
deselect everything else). Run the report. Export to rtf format. Open that
file in Word and do a Search on 'LinkType = "N"' (the full phrase will most
likely be something like: SET myTable.LinkType = "N", assuming that the
culprit is an update query.)
Code solution:
Sub FindStringInQuery(strToFind As String)
Dim db As dao.Database
Dim qdf As dao.QueryDef
Set db = CurrentDb
For Each qdf In db.QueryDefs
If InStr(qdf.SQL, strToFind) > 0 Then
Debug.Print qdf.Name
End If
Next qdf
Set qdf = Nothing
Set db = Nothing
End Sub
FindStringInQuery("LinkType = " & chr(34) & "N" & chr(34))
The names of any queries with the specified phrase should appear in the
debug window.
HTH,
