I'm having a very similar issue, and have no idea how I can best handle this.
The original data sits on a MySQL database. I have read only access into this database. In order to accomplish what I need, I have to manipulate the data in Access. I have linked the tables via ODBC external data...