检查了也不知道哪个select子句有问题？

Private Sub refreshdata()
 Adodc1.RecordSource = "select e.empid, e.empname AS  员工姓名, e.sex AS  性别," _
+ "e.title AS  职务,e.age AS 年龄,e.office_phone AS  办公电话," _
+ "e.mobile_phone AS 移动电话,e.salary AS 工资, d.depname AS 部门名称" _
+ " FORM  employees e ,departments d  WHERE e.depid=d.depid " _
+ "order by e.depid"

Adodc1.Refresh


With DataGrid1
.Columns(0).Width = 0
.Columns(1).Width = 800
.Columns(2).Width = 800
.Columns(3).Width = 800
.Columns(4).Width = 800
.Columns(5).Width = 1500
.Columns(6).Width = 2000
.Columns(7).Width = 1200
.Columns(8).Width = 1200


End With

employees表的别名

查找不出原因，select的语句检查了好多遍，就是不能刷新数据库

实时错误 '-2147217900 (80040e14)':
对象'Refresh'的方法'IAdoc'失败

试了也不行，所有代码检查过了，就是不能实现adodb.refresh
一运行就出现这个错误