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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent Assistance this is exactly what i needed.
Glad to help!
ASKER