receiving confirmation using MYODBC

[wxdqz]

Hi,I am working on a project that involves using a form to populate a MYSQL table. I then need to transfer these records to an Access database. I want to have a flag in the MYSQL table to indicate that records were transfered to Access successfully. When the record is successfully tranfered, I want to return a Y to this field.Has anyone done anything like this?Thanks,Melissa