#Name? displayed in some fields

  • Thread starter Thread starter Steve Mackey
  • Start date Start date
S

Steve Mackey

I have an Access report in a database on a network drive being accessed by
several computers running Access 2003. When the report is run from some PCs,
the data displays normally on the report. However, when run from other PCs,
the same report (accessing the same data records) displays #Name? in some
fields on the report. Is there some external file, perhaps a .DLL file, or
setting that would cause this to happen?
 
The trick will be to see what's different between the computers where it
works, and those where it doesn't.

It could be due to a bad reference:
http://allenbrowne.com/ser-38.html

It could be due to a difference in versions. Compare the version of
msaccess.exe (in the folder where Office is installed) or msjet40.dll (in
Windows\System32), by finding the file in MyComputer, right-clicking and
choosing Version. If you need an update in either, go to:
support.microsoft.com/sp
and get the Office service pack, or the JET service pack.
More info about getting the version info programmatically:
http://allenbrowne.com/ser-53.html

#Name can also be due to a badly named control, e.g. a control that has the
same name as a field, but is bound to something else. #Error can also occur
when a user filters a report such that no records match.
 
Back
Top