Join Query Unpredictable.

[Mod]

So, I have one query in two databases. The query works correctly in a minimal database, where the only existing tables and fields are the ones involved in the query.

The query will not work at all in my real database, and in fact will crash Access in quite a hard manner.

This is the minimal query:

SELECT tbl1.tbl1ID
FROM tbl1 LEFT JOIN tblJunction ON tblJunction.tbl2ID = 2 AND tblJunction.tbl1ID = tbl1.tbl1ID
WHERE tblJunction.tbl1ID IS NULL;

This is the real query:

SELECT Specimens.SpecimenID
FROM Specimens LEFT JOIN ProjectSpecimen ON (ProjectSpecimen.ProjectID = 1) AND ProjectSpecimen.SpecimenID = Specimens.SpecimenID
WHERE ProjectSpecimen.SpecimenID IS NULL;

Trying to save the real query results in "join expression not supported Error 3296" with this part highlighted
ProjectSpecimen.ProjectID = 1

Trying to execute the real query (by switching to datasheet view) will crash Access in just about the ugliest manner possible.

Does anyone see the problem? or a better way to get the same results?