Member Avatar for Mrgrinch12
Mrgrinch12 0 Newbie Poster

I have a database using Access 2003 for the front end and MySQL to store and process all the online queries for the website. Several of the queries I run on the database are done daily as part of creating the data tables to support the site. Some of these queries were taking so long to run on the remote MySQL tables, that I created stored procedures in MySQL. The difference in speed is enormous, but it is also a pain to login to the mySQL database to call up the procedures each day. I know I can create a function to perform the tasks, but that to will be processing the procedure locally and will take too long or error out.
Is there a way to "launch" the stored procedures as part of the data processing in my Access front end?

I did not provide any code as I don't have any idea where to start.

Thanks for any help you can suggest
Scott

  • 1 Contributor
  • 0 Replies
  • 56 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.