MySQL Forums
Forum List  »  Connector/ODBC

Real-time notification to client when table is changed
Posted by: Motti Bazar
Date: April 13, 2020 03:04AM

Hello, I am an experienced developer, starting to use MySQL, using Excel, VBA with ADO, and the Connector/ODBC. I am able to utilize MySQL but I face one issue that I can't find a solution for. As I plan for multiple users working with the database, I need a way that in case one user updates table XYZ, other users displaying the same table in their Excel, will immediately be notified of that and be able to update their displayed Excel table accordingly, to represent the changed table. I need to support this in VBA. Your help will be very highly appreciated and I will publish the full solution when done. Thanks a lot, Motti

Options: ReplyQuote


Subject
Written By
Posted
Real-time notification to client when table is changed
April 13, 2020 03:04AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.