错误3219-无效的操作 [英] Error 3219- Invalid Operation

问题描述

我尝试在Access项目中编写查询，但是此运行时错误发生在SQL查询所在的行中.这是我的代码:

I try to write a query in my Access Project but this runtime error occures in the line, where SQL query is. This is my code:

Private Sub Befehl80_Click()

  Dim rst As DAO.Recordset
  Set rst = CurrentDb.OpenRecordset("SELECT DISTINCT tb_KonzeptDaten.DFCC,  tb_KonzeptDaten.OBD_Code AS Konzept_Obd,tb_KonzeptDaten.DFC INTO Test_Table FROM tb_KonzeptDaten", dbOpenDynaset)

  Me.txtDs = rst.RecordCount

End Sub

请告诉我如何解决此问题以及为什么会发生此错误?

Would you please tell me how can I solve this problem and why this error occures?

推荐答案

sql是一个操作查询，它​​创建一个表.您不能从操作查询中打开记录集.如果要运行操作查询，可以说:

The sql is an action query, it creates a table. You cannot open a recordset from an action query. If you want to run the action query, you can say:

Set db=CurrentDB
ssql="SELECT DISTINCT tb_KonzeptDaten.DFCC,  " _
    & "tb_KonzeptDaten.OBD_Code AS Konzept_Obd,tb_KonzeptDaten.DFC " _
    & "INTO Test_Table FROM tb_KonzeptDaten"
db.Execute ssql, dbFailOnerror

RecordsUpdated=db.RecordsAffected

这篇关于错误3219-无效的操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！