方法'Open'作用于对象'_Recordset'时失败

hug110

Dim rs As New ADODB.Recordset
Dim sql As String
sql = "select * from tblPhotos where PhotoID not in (select ReadPhotoID from Read where ReadYGGH='" & SysUser.YGGH & "')"
                     
rs.Open sql, CurrentProject.Connection, adOpenKeyset, adLockOptimistic

上面的代码运行提示:方法'Open'作用于对象'_Recordset'时失败
请问是那里出错了????

secowu

我也是这样