关于数据库连接的菜问题。

[vgat]

Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.Provider = "Microsoft.Jet.OLEDB.4.0"
conn.Open App.Path & "\linkmen.mdb"
sql = "select * from user"
rs.Open sql, conn, 1, 2, -1

各位高人帮忙看看错在什么地方啊？它说
"实时错误'-2147217900 (80040e14)' from 子句语法错误。"

[naliver]

是不是你的数据库里没有这个user表呀？

[zqfleaf]

Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & app.path & \linkmen.mdb"
sql="select * from user"
rs.open sql,cn,3,1

[zqfleaf]

conn.open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & app.path & _
"\linkmen.mdb"

[heqjxiaoyao]

这是连接字符串的问题

[dengyiwolf]

Set conn = New ADODB.Connection
Set rs = New ADODB.Recordse

conn.connection ="provider= Microsoft.Jet.OLEDB.4.0;data source=app.path &"linkmen.mdb""
conn.Open
sql = "select * from user"
rs.Open sql, conn, adopenstatic, 2, -1