Hello VB experts can you help with a problem with my syntax.
With the code below Im trying to update a field called 'Path' in a table
'tSchoolDetails' to 'dlgDialog.filename' (file selected in the common
dialog), I get the following
run-time error '-2147217900 (80040e14)':
Syntax error (missing operator) in query expression
'E:\path\to\database\mydatabase.mdb'.
any help much appreciated
Ian
Dim adoConn As New ADODB.Connection
Dim adoCmd As New ADODB.Command
Dim strConn As String, strSQL As String
' Open a Connection object
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
strConn = strConn & dlgDialog.filename
adoConn.ConnectionString = strConn
adoConn.Open
' Define a query string
strSQL = "UPDATE tSchoolDetails SET [Path]=" & dlgDialog.filename
' Set up the Command object
adoCmd.CommandText = strSQL
adoCmd.CommandType = adCmdText
adoCmd.ActiveConnection = adoConn
adoCmd.Execute
' Tidy up
Set adoCmd = Nothing
adoConn.Close
Set adoConn = Nothing
