A family of Microsoft relational database management systems designed for ease of use.
Can you provide the SQL view of the query?
I would open the vba/code window (press Ctrl+G) and then attempt to compile the code. You can also check for missing references: Tools->References. See if any of the references suggests "MISSING".