Missing:Microsoft DAO 2.5/3.5 compatibility library

[rajamann 1985]

Hi - I am vinoth, I am unable to run a report from a old access 2003 database which i had , The error which i am getting is "Missing:Microsoft DAO 2.5/3.5 compatibility library" I am not sure what to do ,and my guess is some DLL files are missing , If some one knows the solution please let me know ASAP . The version of access is ms access 2003

[dsatino]

This means that you have some code from a very old version of Access. Your best bet is to simply open the VB window and compile the code. It will fail of course, but you'll be brought to the items that are causing the failure and you update to code that is actually recognized.

[rajamann 1985]

so updating the code is the only solution ? I am not able to open the code , once i open the access database it is throwing the compiler error and when i press OK it doesnt do anything , the exact error which i get is "MISSING:Microsoft DAO 2.5/3.5 Compatibility Library". So if we find the dao350.dll and if we place that in C:\Program Files\Common Files\Microsoft Shared\DAO , will that work ? Let me know what you think . Thanks !

[NeoPa]

You could Google the library name, but here's a link that might help you find a better way than simply finding the library (Missing DAO 2.5/3.5 Compatibility Library). Good luck.

[ADezii]

From Microsoft:
When you Open or Convert a Database that was created in a Version of Access earlier than Access 2000, and you attempt to run or compile older Code that uses Data Access Objects (DAO), specifically in Access 2002, you may receive compile errors. This issue can occur because Access 2002 does not have Compatibility Type Libraries. The only optyion, as I understand it, is to Update the DAO Code.

[rajamann 1985]

ok , how do i update the DAO code ?

[ADezii]

Have you tried the SHIFT ByPass?

[NeoPa]

Rajamann:
ok , how do i update the DAO code ?

Have you even checked the link provided in post #4 yet? I included that because it answers your question. It's not hard to follow a link you know - you just click it with the mouse. The solution is provided by an acknowledged expert in the field and I suspect is more than you need. You barely even need to think.