Compile Error:

[Trudye]

Hi Guys:

I'm getting the folowing error:

compile error: Can't find project or library.

I looked it up in Help and in MS's Knowledgebase. I located the missing DLL files via search of Explorer, pointed both libraries to them. However the "Missing" indication prefixing the libraries did not disappear. I reloaded MS's Developers Library 2000, and then reloaded Office 2000. All that work and BUMPKUS!

I removed the check mark from the 2 effected libraries and the compile error disappeared. This problem just seem to occur out of the blue, my client and I have been running this pgm for months with no problem.

The effected statement was:
curr_month = Month(Date)

What the HECK happend?? I would like to put the libraries back I'm not sure at this point what else will be effected.


Thanks much
Trudye

 

[hermanlaksko]

I have tryed your little code (curr_month = Month(Date)) in a test mdb of mine worked fine, then I removed all refrences and it still worked, as it should.
The month(date) is a part of VBA (one can not remove the vba-ref).
Either something else is wrong or your container (the mdb) is behaving in a erratic way, to solve this I allways make a new empty mdb I then import all my elements from the erratic mdb AND........ the error just evaporates ;-)

I am not saying that this is that case for you but it could be.
Herman

 

[Trudye]

Thanks Herman for the feedback. But as I stated the db now compiles so now my problem is locating my missing libraries:
MS ActiveX Data Obj (multi dimensional)2.51 lib.
MS ActiveX Data Obj recordset 2.51 lib.

I don't want to run into problems trying to allocate jet engine space or files. Or any other problems these two libs reconcile.

Thanks again
Trudye