I have an application which relinks some tables in an Access database using ADOX 2.7. Everything works fine in the development environment. When the setup package is run (on the same machine) and then the INSTALLED program is run, I receive an error "System.IO.FileNotFoundException: File or assembly name Interop.ADOX, or one of its dependencies, was not found." when it attempts to run the code which references the ADOX library
(with, for example...
Dim ADOXTable As ADOX.Table
Dim ADOXCatalog As New ADOX.Catalog
Dim ADOConnection As New ADODB.Connection
The "detected dependancies" include "Interop.ADOX.dll" and the file is in the installation directory with the executable program. The other installed dll's are ADODB.dll and InterOp.ADOR.dll.
MDAC 2.7 is installed on the machine and works fine when the code runs in the development environment.
Does anyone have any ideas on what can be causing the problem or any additional steps I need to take to use ADOX from an installed program?