I'm having a problem with Access not allowing me to use an UPDATE string.
Comes back with this:
Source: ADODB.Field Description: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
Can the locktype be changed?