Results 1 to 1 of 1
2001-06-28, 12:28 #1kennyritchGuest
Exporting from one DB to another DB (2000)
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?