write me an VBA Code which fires a mysql query as a pass through query in ACCESS 2007.
# background information
Access checks the query if it is sql well formend. After you switch to pass through query you can also fire mysql queries to an externals server. I need a vba code what i could only do in the frontend
A Mysql Query is for example is INSERT INTO .... ON DUPLICATE KEY UPDATE .. (which is not supported in ACCESS) which can not be fired in the normal query window - you need to switch to pass through query
11 freelancers are bidding on average $37 for this job
Hello Sir, I am eager to take the project , i will make sure to deliver it successfully, I have wide experience including but not limited to the required one
Hi. I have extensive experience developing in VBA and a lot of experience with MySQL. Please share your Access and your query you want execute in MySQL and I will show you an example