Quote:
Originally posted by fscan
hi,
we have a fingerscan device that saves its data online to an access MDB file.
i am converting the MDB to MYSQL DB using Adump.exe utility.
How can i make the conversion realtime?
when mdb file changes, it automatically export the data to Mysql. how can i do that?
fingerscan maker identix has no support for linux.
thanks
fscan
|
Simplest way:
1. Create Tables in MySQL.
2. Setup ODBC to MySQL
3. Create Linked tables from MySQL in Access
When you update Access then data will be stored in MySQL and so the data will be avalaible for both of them.