Pat, I use to use a Hex Editor on the MF that would allow me to update a flat file in place, BUT you had to know hex/EBCDIC, and you could really screw them up using it also... hee hee hee I know... What about DSAM, used that before also.
ACE some ODBC/OLE DB can not be updated, some you have to have the proper rights (will give that error also). What is the linked table you trying to update.