100分请教数据库问题!!!!!!谢谢大家!!!!!
我写了一个标准模块,代码如下:
Option Explicit '强制变量显式声明
Global DBCon As New ADODB.Connection '定义数据库连接对象
Global TblRct As New ADODB.Recordset '定义记录集
Public Function ConnectToServer() As Boolean
Set DBCon = New ADODB.Connection
DBCon.ConnectionString = "Provider=SQLReplication.OLEDB"
DBCon.ConnectionTimeout = 100
DBCon.Open
ConnectToServer = True
Exit Function
Public Function QueryData(ByVal strSQL As String) As Boolean '查询数据库
Set TblRct = New ADODB.Recordset
Call TblRct.Open(strSQL, DBCon, adOpenDynamic, adLockOptimistic, -1)
If Err.Number > 0 Then
Err.Clear
QueryData = False
Else
QueryData = True
End If
End Function
然后在一个FORM中调用,代码如下:
Private Sub Form_Load()
Dim strSQL As String '定义查询语句
strSQL = "select * from books" '查询语句
If QueryData(strSQL) = True Then '调用查询
TblRct.MoveFirst '移动到第一条记录
Call ShowDate '显示数据
End If
End Sub
问题是:当运行到TblRct.MoveFirst这时,出现错误,错误信息为:实时错误3704 对象关闭时,操作不被允许!
请大家帮我看看问题出在那里,谢谢大家!!!