access 报错，at address 1B0418EE in module 'msjet40.dll' ( 积分: 50 )

sql语句如下：
SELECT
COUNT(A.InfoID) AS InfoCount,
B.InfoTypeName
FROM T_Inforec A
LEFT JOIN T_InfoType B ON a.InfoTypeID=b.InfoTypeID
GROUP BY a.InfoTypeID,b.InfoTypeName

语句在access里查询可以通过，没有问题，在写在AdoQuery里时报以下错误：

Access violation at address 1B0418EE in module 'msjet40.dll'


Delphi6+Office2000

谢谢！

SELECT
COUNT([blue]A.InfoID[/blue]) AS InfoCount,
.......
GROUP BY [blue]a.InfoTypeID[/blue],b.InfoTypeName
请问你一下，T_Inforec 表有哪些字段？

T_Inforec表里的字段很多，有20多个。但在这个查询里面只用到一个，就是InfoID。

接受答案了.