求救 vb连access语句出错

leoo

Adodc1.ConnectionString = Conn
  Adodc1.RecordSource = "SELECT o.LayerId As 编号, o.Roomnum As 房间数," _
            + "o.BuildingNo AS 建筑物名称,o.LayerNo As 具体楼层," _
            + "o.Memos As 备注信息" _
            + " FROM Layer o , Building s " _
            + " WHERE o.BuildingNo=s.BuildingNo" + strSch _
            + " ORDER BY o.BuildingNo,o.LayerNo"
  Adodc1.Refresh
  Set DataGrid1.DataSource = Adodc1

iptton

最好说下出错提示

leoo

Private Sub Form_Load()
Ado_Bld.ConnectionString = Conn   程序运行到这里就出错了  没有其他提示
2# iptton

leoo

from语句出错

leoo

FROM语句出错
2# iptton

ldl1990

好久没写关于数据库的东西了……都看不懂了……