Error inserting filepath into record

[damicomj]

Run-time error '3075':

Syntax error (missing operator) in query expression 'C:\Documents and Settings\etc.pd f'.


I believe I am getting this error because of the space in the file path, but I am not sure. Here is the code:

strTable = "tblSLA"
strColumns = "(LeaseID, SLAAttachment)"
strValues = "(" & Me.LeaseID & ", " & strFile & ")"

strSQL = "INSERT INTO " & strTable & " " & strColumns & " VALUES " & strValues & ";"

DoCmd.RunSQL strSQL

[Mariostg]

Because you insert a string, you are missing single quotes around your file path. It is not appearant here but try:

strValues = "(" & "Me.LeaseID" & ", '" & strFile & "')"