ED:
It works after I installed the mdac2.1. I look at the query and found that all the table names are in twice in the from clause:
SELECT Policies.Subproducer, Policies.First_Name, Policies.Last_Name,;
Policies.Addr1, Policies.Addr2, Policies.City, Policies.State,;
Policies.Zip, Policies.Date_Effective, Vehicles.Vehicle_ID,;
Vehicles.Model_Year, Vehicles.Make, Vehicles.Model;
FROM Policies Policies, Vehicles Vehicles;
WHERE Vehicles.Policy_ID = Policies.Policy_ID;
AND Policies.Last_Name = ?LASTNAME;
ORDER BY Policies.Date_Effective
Do you know why?? thanks
sherry