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).  
uconnfb13Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LucasMS Dynamics DeveloperCommented:
Are you using any other objects in your program?  If you are try re-registering them using regsvr32.

Otherwise, instead of DAO 3.6 use DAO 3.5.
0
uconnfb13Author Commented:
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.
0
nico5038Commented:
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)
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

LucasMS Dynamics DeveloperCommented:
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.
0
Jim P.Commented:
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.
0
uconnfb13Author Commented:
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.
0
Jim P.Commented:
And you don't get a missing or a pop-up when you go into the references on the desktop?
0
uconnfb13Author Commented:
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...
0
uconnfb13Author Commented:
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...
0
nico5038Commented:
Hmm, then try to remove DAO or ADO as they don't cooperate well.

Nic;o)
0
uconnfb13Author Commented:
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?  
0
nico5038Commented:
Then drop the "MS ActiveX Data Objects 2.1" library and try compiling again.

Nic;o)
0
LucasMS Dynamics DeveloperCommented:
String function is in:

C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
0
Jim P.Commented:
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.
0
flavoCommented:
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?
0
uconnfb13Author Commented:
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!  
0
LucasMS Dynamics DeveloperCommented:
uconn:

What's "MS ActiveX Plugin"?  You might want to register / remove that one ... just a shot in the dark.
0
nico5038Commented:
Getting the impression your .mdb got corrupt, try these MS Access database recovery steps:

1) Create a backup of the corrupt database. (Just in case of)

2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.

3) Try these Microsoft solutions:
Repair A97/A2000:
http://support.microsoft.com/support/kb/articles/Q109/9/53.asp
Jetcomp:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956
and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;306204

4) Bit "heavier":
Access decompile:
http://www.granite.ab.ca/access/decompile.htm

5) Try a recovery tool / Table rescue
Table datarecovery:
www.mvps.org/access/tables/tbl0018.htm
Access recovery:
http://www.officerecovery.com/access/index.htm

6) Ask a company (will cost $$'s ! )
http://www.pksolutions.com/services.htm 

check also: http://www.granite.ab.ca/access/corruptmdbs.htm


Nic;o)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
uconnfb13Author Commented:
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.
0
Jim P.Commented:
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$
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.