Not sure why, but there is a module with this code

'On Error Resume Next
'
'Const adOpenStatic = 3
'Const adLockOptimistic = 3
'
'Set objConnection = CreateObject("ADODB.Connection")
'Set objRecordSet = CreateObject("ADODB.Recordset")
'
'objConnection.Open _
'    "Provider=Microsoft.Jet.OLEDB.4.0; " & _
'        "Data Source=D:\promis-e 2007 Data\Databases\PartsDB.mdb"
'
'objRecordSet.Open "SELECT * FROM Parts_Database", _
'    objConnection, adOpenStatic, adLockOptimistic
'
'objRecordSet.MoveFirst
'
'Do Until objRecordSet.EOF
'    Wscript.Echo objRecordSet.Fields.Item("Detailed_Description1")
'    objRecordSet.MoveNext
'Loop

Once I commented this, my update command worked as expected. Oh well...

Thanks anyway
Jon

>I'm trying to run what in VFP would be easy.
>
>In access I'm getting a Compile Error. in query expression 'TRIM([parts_database.user1])'. from this SQL statement
>
>

UPDATE parts_database
>SET parts_database.user1 = TRIM([parts_database.user1]);
>

>
>What gives?