读取Access数据库报错，急

[weaest]

conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\mywork\works\biye\Dat\dat.mdb;;Persist Security Info=False"
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = conStr
conn.Open

Set rs = conn.Execute("select * from user where user = www ")
运行到这里报错：from 子句语法错误，改成
Set rs = conn.Execute("select * from [user] where user = www ")
报错：至少一个参数没有被指定

各位大侠谢谢了

[weaest]

谢谢

[tyochen]

是不是应该这样：
Set rs = conn.Execute("select * from [user] where [user] = 'www' ")

[fishzone]

你用了Access数据库的一些关键字做表名和列名，所以要加上方括号。