I need to update an existing record in a table.
I have been trying two different methods but can't see what I am missing:
First attempt was:
CurrentDb.Execute "UPDATE [MS Access;pwd=" & strPassword & ";database=" & DBpath & "" & DBname & "].[" & tblengagement & "] SET [Close_Time] = #" & Time & "#, WHERE ID = '" & SessionID & "'"
Second attempt:
CurrentDb.Execute " UPDATE [MS Access;pwd=" & strPassword & ";database=" & DBpath & "" & DBname & "].[" & tblengagement & "] " _
& "(Close_Time) VALUES " _
& "(#" & Time & "#)" _
' & "WHERE ID = '" & SessionID & "';"
Error Received:
Syntax error
UPDATE OF MY CODE:
Dim strPassword As String
Dim DBpath As String
Dim DBname As String
Dim tblengagement As String
DBpath = "C:Projects"
DBname = "Data.accdb"
strPassword = "1234"
tblengagement = "tbl_engagement"
'CurrentDb.Execute " UPDATE [MS Access;pwd=" & strPassword & ";database=" & DBpath & "" & DBname & "].[" & tblengagement & "] " _
' & "(Close_Time) VALUES " _
' & "(#" & Time & "#)" _
' & "WHERE ID = '" & SessionID & "';"
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…