Access 97 (and 2000 Runtime) Compile error

[MIKElaw]

Get "Compile Error Can't Find project or library" on a clean install Access 97 and a 2000 runtime package.

When the mdb compiles it stops on functions CurDir, Time and Left. Loaded Sr2b Office upgarde, no difference. Nothing on the Knowledgebase that I could find. It would appear to be a VBA problem but who where what etc. Anyone have any ideas.

 

[MIKElaw]

If under "Tools - References" you have a add-in or similar which is registered as MISSING but would normally contain the function you have called then despite the fact that it is not there and Access knows it is not it still overrides the call to the internal one. Strange or what!

Soln. just unclick it and you are back where you started.

The initiator of this problem was loading Access developer onto my machine

 

[Gzep]

Hi.

Occasionally I have seen the reference appear to become Un-Registered with windows. (or not be correctly registered in the first place - did you use an installer "Setup.exe" to install the database system, or just copy it onto the machine? - setup will register the references for you!)

So in a serious case, rather than re-installing access, use the REGSVR32.exe program to re-register the reference.

syntax is: REGSVR32 <path-and-name of .dll to register>

Gzep.