Question General Reference Error

[ajetrumpet]

All,

I am experiencing a general reference error when opening both Access 2003 and 2007. Attached is the error of the DLL file reference that is broken. Apparently this can happen quite often, and to many other DLL references. I am just looking for some general information on the cause of this. Here is some background:

I have Office 2003 and 2007 both on this machine of mine. I am thinking this has caused the problem. I use both versions of Word, Excel and Access. Just out of curiosity, I'm wondering if the loading and unloading of different version files has something to do with this. It only happens when I open the Access program. The extra attachments here are the pics of what it shows when I switch from version to version. I don't know the details of the different files that need to be loaded, but it seems normal to me for Access to do it, because of the program's sophistication over Excel and Word.

The error that I am experiencing is causing some Access functions to not work correctly. I have recently witnessed object library errors for the Environ(), String(), and a few others I can't think of right now. They have worked for me before. I appreciate any help I can get on this...

 

[NigelShaw]

Hello mate, not spoke to you in a while.

i cannot see any definate dll reference apart from Office re-configuring. the 2 images you have provided i have seen previously on my machine when i had 2003 installed and then installed 2007 on the same drive. every time i started a file in one or the other program version, it re-configured to suit. i used 2 options.

option 1
every file i wanted to open i right clicked and selected open with. some files ( .mdb ) can be set to open with 2003 as default whereas .accde only works with 2007

option 2
i installed the 2007 version on a different drive though it wasnt that stable and i ended up reverting back to option 1.

there is a recent post about this but off hand, i couldnt tell you how long ago it was up.

Overall, option 1 worked well for me as long i kept 2007 created files with 2007 and true 2003 files with 2003 only.


Nigel

 

[ajetrumpet]

Thank you Nigel. And the 3rd file, the reference error, I had deleted for a few seconds while you were aparently responding to this. Sorry about that. If you want to look, it is there now. Anyway, I am currently using your option 1 method, and have been ever since I installed both versions on my machine. I don't believe this is relevant to the DLL error actually,. but I do the same thing as you. Thank you for the response.

 

[NigelShaw]

Hi AJ,

a quick search brought up the file need. it is used by Yahoo mail and for what i found, seems every now and again to be problematic all on its own. ( probably Yahoo attempt of world domination like G**gle ).

seemingly, you can un-register it and it should solve the problem
enter regsvr32 ymmapi.dll /u

it does state that if the file is found here
C:\Program Files" (mostly C:\Program Files\YAHOO!\COMMON\)
then it is definately linked with yahoo otherwise if it is in system32, its probably malware disguised as ymmapi. it suppose to cause problems with many applications.

i found some basic info here
http://www.file.net/process/ymmapi.dll.html


regs,

Nigel