MySQL Forums
Forum List  »  Connector/ODBC

Re: MS Access 2013 & MySQL OBDC Fail to Link To Tables
Posted by: seo sew
Date: August 06, 2014 03:22AM

Create a DSN to connect to the Northwind database on a SQL Server.
Link the following tables from the Northwind database: Customers, Orders, and Order Details.
Create the following query, and then save it as qryLevel1:

SELECT dbo_Customers.CompanyName, dbo_Orders.OrderID
FROM dbo_Customers INNER JOIN dbo_Orders ON dbo_Customers.CustomerID = dbo_Orders.CustomerID;


Create the following query and then save it as qryFinal:

SELECT [dbo_Order Details].ProductID, qryLevel1.OrderID
FROM [dbo_Order Details] LEFT JOIN qryLevel1 ON [dbo_Order Details].OrderID = qryLevel1.OrderID;


Run the qryFinal query. Note that you receive the error message that is mentioned in the "Symptoms" section of this article. When you run this same query on a computer that has the latest edition of the Jet Service Pack installed, the query runs as expected.
Visit :http://www.seosew.com

Options: ReplyQuote


Subject
Written By
Posted
Re: MS Access 2013 & MySQL OBDC Fail to Link To Tables
August 06, 2014 03:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.