Hi Folks

I've got an external mySQL DB on our server and use a local 'Access' front-end form to help me view the data in a nice user-friendly way.

Data in the DB is often changed and therefore I overwrite previous info with new info. I would like a button on the form that allows me to store the historical data in another table in my external mySQL DB (or maybe a simple text file?) so that I don't lose it completely.

Does anyone know how I can do this or have any ideas as to where I could find out more about this technique. Presumably it can be done?