Joins between feature classes and Access query tables via on OLE DB connection does not work.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM000117
Submitted
October 21, 2005
Last Modified
June 5, 2024
Applies to
No Product Found
Version found
9.0
Status
Known Limit
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
Additional Information
No Public Explanation
Workaround
Instead of using the Access query table, create the query using the tables from cust_service_db_91505.mdb with the Make Query Table tool.1. Add the MeterBoxes.2. Add the 4 tables to ArcMap directly from the Access database.3. Use the Make Query Table tool to create the LocationIDs query in ArcMap.4. Join the query table to the MeterBoxes.