I think the DBA is all wet, but I'll reserve judgement until we solve it. What is the SQL of your query?
He was able to run the query against the SQL database directly using the virtually the same SQL code I had in Access and did so successfully.
When I used the Make Table button using my existing query it worked with no problems. It's only happening when I run the query directly. Here's the code:
SELECT ENCOUNTER.MRNTreatHospitalAbbreviation,
FINANCIALTRANSACTION.ServiceDate,
FINANCIALTRANSACTION.PostingDateFormat,
FINANCIALTRANSACTION.ActivityCode,
FINANCIALTRANSACTION.ActivityCodeDescription,
FINANCIALTRANSACTION.CPTCode,
FINANCIALTRANSACTION.TransBillUnits,
FINANCIALTRANSACTION.Units,
FINANCIALTRANSACTION.DetailTotalAmount,
FINANCIALTRANSACTION.AccountingPeriod,
FINANCIALTRANSACTION.AccountingYear, [Formulary List with NDCs and CDMs].[NDC Code], [Products NDC to GCN].GCN, FINANCIALTRANSACTION.RevenueCenterCode
FROM (ENCOUNTER RIGHT JOIN FINANCIALTRANSACTION ON ENCOUNTER.AccountandFacility = FINANCIALTRANSACTION.AccountandFacility) LEFT JOIN ([Formulary List with NDCs and CDMs] LEFT JOIN [Products NDC to GCN] ON [Formulary List with NDCs and CDMs].[NDC Code Text] = [Products NDC to GCN].NDC) ON FINANCIALTRANSACTION.ActivityCode = [Formulary List with NDCs and CDMs].[Charge Code]
WHERE (((FINANCIALTRANSACTION.PostingDateFormat)>"07/01/2015") AND ((FINANCIALTRANSACTION.RevenueCenterCode)="30200"));