Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

FM & MySQL via MyODBC Questions (real time updates

ofcc
in External Data Sources

Featured Replies

  • Newbies

Hello, I'm brand new to FM Pro. (one hour brand new to the demo).

I have a test database running on MySQL that can be accessed from MS Access through ODBC. When updates are made in MS Access they appear immediately in MySQL. MS Access considers this "linked" or linking to the table instead of replicating the database to the local drive.

I've setup FM Pro using the same ODBC design. However, when I create the connection I'm prompted for a filename and the data is saved locally. I really don't know if/how updates are being sent back to the database on the MySQL server.

Is it possible to use FM Pro as a user interface to a remote MySQL database and have updates take place in realtime?

The goal here is to allow two different groups of people with different skillsets use the same data. If realtime changes from FM Pro are not possible when are changes sent back via ODBC? When the file is saved locally?

If there is any detailed documentation about this online, point me to it smile.gif

Thanks...

  • 6 months later...

Did you ever get more detailed info regarding this?

Is the mysql data saved locally and the the entire mysql table uploaded on save in FM thereby overwriting the live remote table? I sure hope not frown.gif

  • 1 month later...

It doesn't seem so, unfortunately, i have been seeking the same answers...

Create an account or sign in to comment

https://fmforums.com/topic/29153-fm-mysql-via-myodbc-questions-real-time-updates/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.