I have a VB6 program running fine on the machine I wrote it. When I create and exe of the program that works also. If I export the program to another machine I get a 'Class not registered. Looking for object with CLSID {00000010-0000-0010-8000-00AA006D2EA4}' error.
After a bit of research I found here It says that This error occurs when the Visual Basic 6.0 project references the Microsoft Data Access Objects (DAO) 3.6 Object Library (DAO360.dll) and not DAO350.dll. The {00000010-0000-0010-8000-00AA006D2EA4} CLSID is associated with DAO350.dll.
It goes on to say that to fix it you can resolve this problem by setting the Connect property of the intrinsic Data control to Access 2000, which uses DAO360.dll. Unfortunately I don't appear have that option in my VB6 compiler. So laterally thinking I installed DAO350.dll on the other machine. Now I get a 'Data Access Error' instead!
The .mdb database is installed in the directory the machine is expecting it to be in so I don't think it's because it cant find the file. But why wont it work?
Many thanks for any help.