Discussion on:

Use Microsoft Jet's ShowPlan to write more efficient queries

Please correct the SQL statement shown in listing A. The statement currently shown produces a "Syntax error in FROM clause" error message. The correct SQL statement is:

SELECT Products.ProductName, [Order Details].UnitPrice, [Order Details].Quantity, Customers.CompanyName
FROM (Customers
INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID)
INNER JOIN (Products INNER JOIN [Order Details] ON Products.ProductID = [Order Details].ProductID)
ON Orders.OrderID = [Order Details].OrderID
WHERE ((([Orders].[ShipCity])="Madrid"));

It is good to see internal movement in query. thanks for this article.
for ON and OFF of registry value setting from ms-access, I use
advapi32.dll in system32 directory.