All the references that should be there, are there. I know this for sure because THE VERY SAME ADP file runs under Access XP but not under Access 2003.
To be clear:
The ADP file and the SQL database reside on machine A
Access 2003 is on machine A
Access XP is on machine B
When Access 2003 runs the ADP it gets the "error in loading DLL" message, but Access XP runs the very same ADP (not an identical copy, the very same file) okay.
So clearly on machine A there is either a missing or faulty DLL. I just need to know WHICH DLL is missing/faulty?
These are the references that are ticked:
MSACC.OLB Microsoft Access 10.0 Object Library
STDOLE2.TLB OLE Automation
MSADO26.TLB Microsoft ActiveX Data Objects 2.6 Library
SQLDMC** Microsoft SQLDMO Object Library
MSCOMCT2.OCX Microsoft Windows Common Controls-2 6.0 (SP4)
(** these locations are so long that not all the filename can be seen)