Sometimes I’ve seen #Name? on MS-Access reports.
When it appears, the report is impossible to export to excel.
Rather than pull your hair out, check to see if the correct ADO reference is loaded in Tools / References. Usually the problem shows up as a missing reference. Fix the reference and the problem goes away.
The REAL challenge is when you’re deploying and MDE or ADE, because the end user can’t change tools / references.
In this case, you should make sure that the DLL MSADO15.DLL is registered. On my machine it lives in “C:\program Files\common Files\System\ado”.
The command to register this file manually is:
regsvr32 “C:\program Files\common Files\System\ado\msado15.dll”