注册 登录
编程论坛 ACCESS论坛

执行删除记录时的错误!!!请教高手帮忙指导!

花渊美步 发布于 2008-10-13 10:18, 2228 次点击
Set dbPanda = DBEngine.Workspaces(0).Databases(0)
               
                strSQL = "SELECT * FROM FinalConfirm WHERE (((FinalConfirm.RefNo) Like '*" & getOrgRefNo(Forms![F_FConf]![cboRefNo]) & "*'))"
               
                Set rsPanda = dbPanda.OpenRecordset(strSQL, dbOpenSnapshot)
               
                With rsPanda
                    If Not .EOF Then
                        If MsgBox("System will delete the old data", vbOKCancel + vbQuestion, "FinalConfirm") = vbOK Then
                        Do While Not .EOF
                                [bo].Delete[/bo]
                                .MoveNext
                            Loop
                        End If
                    End If
                    .Close
                End With
                Set rsPanda = Nothing
                dbPanda.Close

[bo].Delete[/bo]这里提示错误:
只有本站会员才能查看附件,请 登录

这是什么原因啊?
我已经试了很多方法都不行!
有谁能帮我解决下!
3 回复
#2
花渊美步2008-10-20 10:07
已经解决了,数据的问题,没有操作权限。
这段代码没问题的。
#3
riospark2008-11-26 17:21
哦.. 又学到了一个咯.. 呵呵
1