Improve company productivity with a Business Account.Sign Up

x
?
Solved

Display MySQL Derived Table in MS Access

Posted on 2014-04-21
3
Medium Priority
?
485 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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

607 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