Designing a database application. How to link two bases?

Question

MySQL

Hello friends!
I ask for your help in designing an application for synchronizing two databases.
Subject:
There is a local database with applications (MS Access *.mdb), and an application that works with it (there is no access to the application) The table of this database stores statuses ("accepted", "not accepted", "in processing", etc. .) and the date of creation, there are about a thousand records.
There is a second database of the website (MySQL), in which these very requests must be loaded and updated, the table structure will be slightly different. The site displays these applications.
Actually the question is how to properly organize auto-update and transfer data from a local database to a remote one?
In what format should this data be sent?
How can I find out if the data in the local database table has been changed?
Are there ways to display SQL queries against a local database?
There is an idea to make a small Delphi application for Windows, since all the necessary drivers are there and can already be used. And if you use the mysql driver for a remote database - how can you encrypt the transmitted data?
It may be worth doing everything differently here, but I'm still a beginner and I will be very grateful for any ideas and advice. Thank you.

Answer 1

Read about database replication.
I think the app is redundant.