Solved

Display MySQL Derived Table in MS Access

Posted on 2014-04-21
3
462 Views
Last Modified: 2014-04-21
I have a MySQL stored procedure that creates two temporary derived tables then selects from them with a join.  I need to get the records from the select into MS Access and I haen't been able to get it to work.  I call the stored procedure and it executes correctly.  I just don't seem to be able to get the record set from a temp table with a pass-thru or "DoCmd.TransferDatabase acLink"

I'm using MS Access 2010 and MySQL 5.1.46.

Does anyone know a way to do this?
0
Comment
Question by:jriggin
  • 3
3 Comments
 
LVL 1

Author Comment

by:jriggin
ID: 40013966
The stored procdure is called from VBA in MS Access via ADO
strConnection = "Driver={MySQL ODBC 5.2a Driver};SERVER=192.168.0.44;User=myuser;PASSWORD=password1;DATABASE=asterisk;option=3"
Set cn = New ADODB.Connection
cn.Open strConnection
cn.Execute ("call spStoredProc('Campaign','2014-04-21','2014-04-21');")

Open in new window

0
 
LVL 1

Accepted Solution

by:
jriggin earned 0 total points
ID: 40014008
0
 
LVL 1

Author Closing Comment

by:jriggin
ID: 40014010
I figured it out with help from google :)
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Creating and Managing Databases with phpMyAdmin in cPanel.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question