Very Computer

I have a VB app that uses ODBC to execute a UNION QUERY against a Jet
Database
using version 4.00.3711.08 of ODBCJT32.DLL.  The query looks like this

SELECT  Plan.GroupNumber,
               Plan.AdminSpecValue as EmpCaseValue,
               "AD" as EEType
FROM Plan, Adminspecialists
WHERE Plan.AdminSpecialistID = Adminspecialists.EmployeeID
UNION SELECT Plan.GroupNumber,
               Plan.AcctSpecValue as EmpCaseValue,
               "AC" as EEType
FROM Plan, AccountSpecialists
WHERE Plan.AcctSpecialistID = AccountSpecialists.EmployeeID;

This query worked fine with the 3.51 version of the Access ODBC driver
but gives the message "Too few Parameters.  Expected 2." in the 4.00
version.  The "AD" as EEType and "AC" as EEType statements
cause the problem.  Take these out and it runs fine.  I was wondering
if anyone else has had a similar problem and what they did to fix it.

Any help appreciated!

Dave