VB reports: [Microsoft][ODBC Microsoft Access Driver] Characters found after end of SQL statement. (error #-2147217900)
Best Guess:
Programmer error: Unknown selector in GET exception handler. Last SQL= SELECT MfgModelPages.PDfileName, MfgModelPages.MFfileName, MfgModelPages.CTfileName, [_ModelMfg].MfgModelID, [_ModelMfg].Dept, [_ModelMfg].FirstOfPrimeCategory, [_ModelMfg].MaxOfHighestPrice, [_ModelMfg].MinOfFakeUPC, [_ModelMfg].OnHand, Manufacturers.MfgName, [_ModelMfg].MfgModelNo, Mid([FirstOfSearchForDescr],InStr([FirstOfSearchForDescr],[MfgModelNo])+1+Len([MfgModelNo])) AS Descr, [_ModelMfg].ThumbDir, [_ModelMfg].ThumbFile, [_ModelMfg].MaxOfProductAddDescr, Manufacturers.DefaultImage, [_ModelMfg].FirstOfSearchForDescr FROM (_ModelMfg LEFT JOIN Manufacturers ON [_ModelMfg].MfgID = Manufacturers.MfgID) LEFT JOIN MfgModelPages ON [_ModelMfg].MfgModelID = MfgModelPages.MfgModelID WHERE ( (([_ModelMfg].OnHand) > 1) And ((ThumbFile) Is Not Null) And ((ImageFile) Is Not Null) ) AND [_ModelMfg].MfgID = 200431 ORDER BY Dept, FirstOfPrimeCategory, MaxOfHighestPrice DESC;WHERE ( (([_ModelMfg].OnHand) > 1) ) AND [_ModelMfg].MfgID = 200431 ORDER BY Dept, FirstOfPrimeCategory, MaxOfHighestPrice DESC;