[IMail Forum] ODBC Update Errors

[James Nelson]

I've been digging through the archives & Ipswitch's KB for info on this, but I'm coming up blank.  We have a mySQL user database that is in a custom format for accounting & other purposes.  We then have an Access database that runs a select query to put the information in the format that Imail expects (works surprisingly well even with 3000+ users).  This is what IMail connects to through ODBC.  The user account that Access uses to read the mySQL database with only has SELECT permission, since any user editing is done through other methods that work with our custom program.  However, Imail keeps logging information like this in the sysmmdd.log file:   07:16 14:40 ODBC(144036197) (Table: xxxxx) Update User : (Error: # 23000 : [Microsoft][ODBC Microsoft Access Driver] Field cannot be updated.) 07:16 14:52 ODBC(145253197) (Table: xxxxx) Update User : (Error: # 23000 : [Microsoft][ODBC Microsoft Access Driver] Cannot update 'FULLNAME'; field not updateable.) Now it is obvious why these fields are not updateable (it doesn't have permission).  But I'm trying to figure out *why* it's trying to change these fields.  Can anyone shed any light on this, or give me some leads on where to continue troubleshooting?  Thanks.   ::James Nelson