JOIN issue in Access

[Muddmuse]

When running the following query against Access I get the "Item cannot be found in the collection corresponding to the requested name or ordinal" error.

SELECT u.id, u.name, u.active, ut.descr FROM tblUsers AS u LEFT OUTER JOIN tblUserTypes AS ut ON ut.userType = u.userType

Using the same query against SQLServer runs fine. What's up with Access?

 

[lupins46]

'name' is a reserved word.
Put [ ] around it.

 

[Muddmuse]

thank you!