leoo 发表于 2009-5-10 11:07

求救 vb连access语句出错

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 发表于 2009-5-10 11:22

最好说下出错提示

leoo 发表于 2009-5-10 15:32

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

leoo 发表于 2009-5-10 16:40

from语句出错

leoo 发表于 2009-5-10 16:41

FROM语句出错
2# iptton

ldl1990 发表于 2009-8-24 01:18

好久没写关于数据库的东西了……都看不懂了……
页: [1]
查看完整版本: 求救 vb连access语句出错