uconnfb13
asked on
Some user's receiving "Compile Error: Can't find project or library". No References flagged as MISSING.
I have developed an application for a client that has been running fine for a few months now, but suddenly they get the error. It happens when the application tries to run code with the String function: ipBuffer = String(lngSize, 0&). I have checked their References and none are marked as MISSING. They have the following references:
Visual Basic for Application
Microsoft Access 11.0 Object Library
OLE Automation
MS DAO 3.6 Object Library
MS ActiveX Data Objects 2.1
MS ActiveX Plugin
As far as anyone knows, no updates or Service Pack installs have been done to either Access or the OS -- it just suddenly stopped working. They are running Access 2003 on MS XP Professional 2002 SP2. What's most troubling is that it suddenly happened to two of the users, not just one; and the fact that other users running the exact version of Access and OS have no trouble running through the code, with the same References selected. Please help! I've run out of ideas and can't find any other posts with this issue (that wasn't resolved by fixing a MISSING reference).
Visual Basic for Application
Microsoft Access 11.0 Object Library
OLE Automation
MS DAO 3.6 Object Library
MS ActiveX Data Objects 2.1
MS ActiveX Plugin
As far as anyone knows, no updates or Service Pack installs have been done to either Access or the OS -- it just suddenly stopped working. They are running Access 2003 on MS XP Professional 2002 SP2. What's most troubling is that it suddenly happened to two of the users, not just one; and the fact that other users running the exact version of Access and OS have no trouble running through the code, with the same References selected. Please help! I've run out of ideas and can't find any other posts with this issue (that wasn't resolved by fixing a MISSING reference).
ASKER
thanks for your quick response, lucas911. What do you mean when you ask if I'm using any other objects in my programs? Also, I don't see DAO 3.5 as an option -- it's not listed.
What happens when you sun in the VBA mode a "Debug/Compile all Modules" ?
Make sure no errors occur or try to solve them.
Nic;o)
Make sure no errors occur or try to solve them.
Nic;o)
For example, i'm using an animated gif in my DB. So i needed to register the GIF89.DLL file.
Without registering that file first, when i open my DB i get all kinds of errors.
Do you only have DAO 3.6? Try some other version if there is an option.
Without registering that file first, when i open my DB i get all kinds of errors.
Do you only have DAO 3.6? Try some other version if there is an option.
Acc2K? Has anything else been installed on those 2 PCs?
Find the actual files for those references and make sure their version info is correct.
Find the actual files for those references and make sure their version info is correct.
ASKER
Nico, this is a shared mdb file that is on a shared directory. From my laptop, I can compile the app just fine, but from the desktop in question (the one that gets this error), will get the "Can't Find Project or Library" message when doing a Compile all Modules.
And you don't get a missing or a pop-up when you go into the references on the desktop?
ASKER
Access 2003. jimpen, how can I determine the version info for the files for the references? I assume you mean all the References that are checked on those 2 pcs? I tried re-registering the VBE6.DLL file, which I believe is the one used for the "Visual Basic for Applications". My next step is to re-install Access on these 2 pc's, though I'm not expecting success...
ASKER
No missing in the references on the desktop...that seems to be the most common solution for this error message! That's why I'm stumped...
Hmm, then try to remove DAO or ADO as they don't cooperate well.
Nic;o)
Nic;o)
ASKER
Only MS DAO 3.6 Object Library is being used, no ADO. This function "String" that's fouling things up...which library is that in anyway?
Then drop the "MS ActiveX Data Objects 2.1" library and try compiling again.
Nic;o)
Nic;o)
String function is in:
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
On the bottom of the the references when you select one it say "Location:" track the file down and right clikc properties and the version tab.
What ActiveX control are you using?
Have you tired re-registering it?
Do you *really* need it?
Can you create a new container (mdb) and use the String function in the fresh mdb file?
Have you tired re-registering it?
Do you *really* need it?
Can you create a new container (mdb) and use the String function in the fresh mdb file?
ASKER
Another computer suddenly is getting this error! Would any auto-office or Windows updates do this?? I can't think of any reason why the application, which has had no changes, would suddenly stop working from one computer at a time!
uconn:
What's "MS ActiveX Plugin"? You might want to register / remove that one ... just a shot in the dark.
What's "MS ActiveX Plugin"? You might want to register / remove that one ... just a shot in the dark.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All,
It seems that a Window's XP auto-update for ActiveX fouled things up. We un-did that update, and it works fine. Obviously this isn't a long term solution, as we can't stop running the windows auto-updates indefinitely, but at least we isolated the issue.
It seems that a Window's XP auto-update for ActiveX fouled things up. We un-did that update, and it works fine. Obviously this isn't a long term solution, as we can't stop running the windows auto-updates indefinitely, but at least we isolated the issue.
If you block the direct download sites from the web and setup WSUS you can control which updates get approved.
And in the meantime submit a bug complaint to M$
And in the meantime submit a bug complaint to M$
Otherwise, instead of DAO 3.6 use DAO 3.5.