Solved

Display MySQL Derived Table in MS Access

Posted on 2014-04-21
3
466 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access Form - Button Format Issue 13 45
SQL Procedure 7 49
Access Report via Windows Desktop Shortcut 12 42
Tabbed form question 5 18
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

732 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