Missing or broken reference

[mazza]

I have created an MS Access Application in Access XP (2002/2000).
Users are using this applications through Access Runtime (2002).
For some reason after changing my PC everytime I copy the application from eg my harddrive onto our server drive users are unable to open the application through runtime and the following message appears

"Your database or project contains a missing or broken reference to the file 'OWC10.DLL' version 1.1"

users are unable to open the application.

I have tried replacing their 'OWC10.DLL' file with mine but that didn't work.

Any suggestions
:

 

[MStef]

Hello mazza!
Open any VBA (form or module),
click on Tools icon, click on REFERECES,
in Available References disconnect all
MISSING references. Try your app again.

 

[mazza]

Seems to have worked. Just hope it doesn't get temperamental.

thanks

 

[TDHAccess]

Hi Guys,

Had the very same problem where I work. The cause was this:

I was working from home via RDP and the RDP server was running Office XP SP3. The guys in the office were running office XP SP2.

giving the same error message:

Your database or project contains a missing or broken reference to the file 'OWC10.DLL' version 1.1

Looks like we may have to roll out SP3 across all machines, unless you guys know of another way.

Thanks

 

[modest]

Dynamically choose the reference by loading them when you need them... and make sure you remove them when you leave the application. Removing them will ensure no "MISSING" references when you open from a different application. **Edit: this is not entirely correct**


See my example database for a sample of how to open references that depend on a certain dll version.

Remember... just copying and pasting a dll does not work. You must register the dll. The easiest way to do this is go into your Run command on your Start Menu and type: Regsvr32 "C:\Full File Path"