注册 登录
编程论坛 ACCESS论坛

[求助]我连接数据库为什么会出错呢?

minwen369 发布于 2006-04-28 19:41, 772 次点击

Dim id As String
Dim pwd As String
Dim ws As Workspace
Dim db As Database
Dim rs As DAO.Recordset
Dim sql As String
Set ws = DBEngine.Workspaces(0)
'打开数据库地址
Set db = ws.OpenDatabase("F:\我的作品\数据库\学生考勤\xs.mdb")
If IsNull(Me.Text10) Or IsNull(Me.Text12) Then
MsgBox ("请输入完整")
Else
id = Trim(Me.Text10)
pwd = Trim(Me.Text12)
sql = "select * from xs where xh='" & id & " ' and pas='" & pwd & "'"
'数据库执行查询,并把结果放入rs
set rs = db.Execute(sql)
End If


出错对话框在附件里
我要怎样才能正确连接这个数据库呢?请大家帮忙看看吧,谢谢

1 回复
#2
hanyuxinghu2006-05-10 22:04
没有看到附件的呀!?
1