MySQL, Access, ODBC, Replication

[Beda Christoph Hammerschmidt]

Hello,

i have a central mysql database that is accesed by multiple clients
running MS Access with ODBC.
This works fine if Access has a permanent connection to mysql.

But now, i want MS Access to operate offline (e.g. on notebook in the
field).
I tried to create a local replica of the ODBC database, but the local
replica still requires an ODBC connection to the running mysql server.
I do not know why.


What is teh best way to realize synchronization between a local and an
odbc database using MS Access ?

Thanks in advance

Beda