sql - INSERT INTO 语句中的语法错误（错误 3134）

Question

我正在使用 MS Access 2013。我当前的问题是以下代码，我用来记录用户活动。表被称为：tbl-activitylog并有五列：

id
timestamps
Username
Activity
Additional

我在一个又一个字符之后检查了很多次代码，但不知道出了什么问题:(

TempVars("UserName").Value = "admin"
Logging("Logon", "system")
Public Sub Logging(Activity, Additional As String)
    Dim sql_code As String
    sql_code = "INSERT INTO tbl-activitylog(Username, Activity, Additional) VALUES('" & TempVars("UserName").Value & "','" & Activity & "','" & Additional & "')"
    Debug.Print sql_code
    CurrentDb.Execute sql_code
End Sub

调试打印显示：

INSERT INTO tbl-activitylog(Username, Activity, Additional) VALUES('admin','Logon','System')

标签： sqlvbams-access

Answer 1

因为使用“-”你必须这样做[tbl-activitylog]

sql_code = "INSERT INTO [tbl-activitylog](Username, Activity, Additional) VALUES('" & TempVars("UserName").Value & "','" & Activity & "','" & Additional & "')"