Hi Mike,

Great, that works fine for me!

Unfortualy I've to rewirte a lot of queries because of that limitation :-/

Con. Access: I've a Access FrontEnd/BackEnd application where I upsize the BackEnd...

I've the same problem. But your workaround doesn't solve my whole problem.

I want to edit table 'Pers' and sort it by 'Pers_Ex.SortOrder'

Here is the example:

SELECT Pers.Name

FROM Pers INNER JOIN Pers_Ex...