September 24, 2015 at 3:00 pm
Maybe I'm using a later version of Access than I should, but I figured I would ask around before doing something drastic.
I have a simple report based on an Access 2013 query (just to confuse things, it's an Access version of a SQL Server database, but never mind that!). This one works:
SELECT EnglishProductCategoryName AS Category, EnglishProductSubcategoryName AS Subcategory, EnglishProductName AS ProductName
FROM ProductMaster
ORDER BY EnglishProductCategoryName, EnglishProductSubcategoryName, EnglishProductName
but when I try to use a query that joins multiple tables, like this one:
SELECT DimCustomer.MaritalStatus, DimCustomer.Gender, DimCustomer.YearlyIncome, FactInternetSales.ProductKey, FactInternetSales.OrderDate, FactInternetSales.OrderQuantity, FactInternetSales.ExtendedAmount
FROM FactInternetSales INNER JOIN DimCustomer ON FactInternetSales.CustomerKey = DimCustomer.CustomerKey;
It throws this error:
An error occurred while executing the query.
The MS Office Access database engine cannot read the data in FactInternetSales.
The minimum required version to read the data is 14.0.0000.0000
I ran the "FixIt" tool on the MS website to remove 32-bit Office components from my computer, but no joy. Any thoughts on how to fix it? (I would try a linked server to the Access database, but that doesn't want to work either... same 32/64-bit incompatibility).
Do I just reinstall from scratch?
September 24, 2015 at 7:50 pm
Okay, that's weird. Works if I create SQL for the query in Access then paste it into the Query window. Otherwise, doesn't seem to work. Maybe the moral of the story is "Access: Just say no."
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply