I have this query that works great in vb6, but I am rewriting it for .net 2010. In query builder it tells me that the = sign is not recognized.

Code:
SELECT DISTINCT Division, SUM(IIF(`Software Title`= 'MS Office Std', 1, 0)) AS StdProdist, 
SUM(IIF(`Software Title`= 'MS Office Pro Plus', 1, 0)) AS ProProdist
FROM `MS Office Licenses`
Why does it work in vb6 but not .net 2010? Same database is being used, ms access. Same jet engine, or a version of the jet engine.