VBA连接本地Access数据库报自动化错误,回答正确追加至满分

2024-12-03 07:56:27
推荐回答(1个)
回答1:

Dim adoCurCon As New ADODB.Connection
Set adoCurCon = CurrentProject.Connection '去掉这拆销棚斗颂句旅则

Dim AdoCurResTM As New.ADODB.Recordset
Set AdoCurResTM = adoCurCon.Execute(strSql) '去掉这句
AdoCurResTM.Open strSql,adoCurCon,2,2