Solved

Display MySQL Derived Table in MS Access

Posted on 2014-04-21
3
460 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

912 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now