Error Occurred when compressing Access 2003 Database

Question

Hi I have build application in vb.net 2005 and using Access 2003 database. When i am compressing database then it is showing error message which is below. Could not load file or assembly 'Interop.DAO Version=5.0.0 Culture=neutral PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. Any one can suggest me what i am doing wrong and when this type of error occurred. Thanks in Advance. Regards Dharmchand Dhingra

Dharmchand Dhingra · Answer

Hi I found the solution of this problem. The problem was that on target machine. On target machine .net framework was corrupted. and i repair framework then it is working correct. Thanks n regards Dharmchand Dhingra

Dharmchand Dhingra · Answer

Hi Thanks for quick reply. Yes Interop.DAO is a library file. how can i find this type of conflict problem in target machine. Actually i have tested this at my pc it is working correct. but the problem comes from my client PC. So how to recognize this conflict problem. if there is any steps for this then please suggest. and finally what is MDAC 2.5. i dnot know about MDAC 2.5. and did not installed on my machine. how can i check is this installed(means what name is in control panel->add/remove program)? Thanks and regards Dharmchand Dhingra.

Lalit M · Answer

1) Don't install MDAC 2.5. 2) The Interop.DAO.dll is looking for a particular version of the DAO library. 3) There must be a conflict between the versions that may already exist on the target machine.