Code Snippets

This code is helpful! Run it in a (temporary) query designer and it will find queries that reference a named table. (I’ve just been doing the “so what depends on this process?” process…)

SELECT DISTINCT MSysObjects.Name
FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId=MSysObjects.Id
WHERE (((MSysQueries.Name1) Like "*" & [TableName] & "*")) OR (((MSysQueries.Name2) Like "*" & [TableName] & "*"))