If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > live query from access MDB to MYSQL

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-05-04, 03:37
fscan fscan is offline
Registered User
 
Join Date: Apr 2004
Posts: 3
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
Reply With Quote
  #2 (permalink)  
Old 04-05-04, 07:34
ika ika is offline
Registered User
 
Join Date: Oct 2003
Location: Slovakia
Posts: 482
Re: live query from access MDB to MYSQL

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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On