Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: live query from access MDB to MYSQL

    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

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: live query from access MDB to MYSQL

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •