|
You can very easily read and write from a MySQL database, there are code examples on this forum, although IIRC its limited to scalar variables only.
If you really have to use Aceess, then I assume you could store the data in the MySQL tables, and then link these to Access, assuming there's a suitable driver available. Using MySQL is definately the easiest option.
An easy solution is to use a text file, writing data import and export functions in Access, thats the approach that I used for years, its a bit clunky, but it works.
Alternativey you could write a dll, or use a webservice, I've seen examples of both on various forums generally using SQLServer as the db, but it should be simple enough to modify these. Theres certainly an example on the metaquotes forum of writing tick and bar data to SQL Server.
|