Avatar of EasyToHelp
EasyToHelpFlag for South Africa asked on

ACCESS System Update a MySQL Database

I have an MS access system that i need to update a Mysql System when the access table is saved. The Mysql Database will never update the Access Database only the Access Database Must update the Mysql Database.

In both databases i have a field PRODUCT_CODE and PARENT_PRODUCT_CODE

If they exist, they must be updated,
If they do not exist they must be added ONLY if they contain a value in a specific column(PARENT_PRODUCT_CODE)

Microsoft AccessMySQL Server

Avatar of undefined
Last Comment
SStory

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
SStory

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
EasyToHelp

Yes it is a form, How would i trap the events in Acess ?
SOLUTION
Manfred35

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
EasyToHelp

Excellent Assistance this is exactly what i needed.
SStory

Glad to help!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck