Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Display MySQL Derived Table in MS Access

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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

572 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