Breaking a reference via code

[Lance McGonigal]

Thanks all in advance for your help.

Does anyone have some sample code to break a reference to an addin titled
"LmLib". I set the reference each time I start the code but if the user
moves the application it fouls up.

On startup of the app I need to:

1. break the reference
2. add the reference back in from a file in the applications path titled
LmLib.mde (I have this working).

Thanks again.

 

[Graham R Seach]

Lance,

The code at the following site will help:
http://www.papwalker.com/

When you get to that site, click [Developer] from the left frame, then [DLL
Hell].

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[M.L. Sco Scofield]

I'm not sure if you can break a reference or if you need to or want to.

Have you simply tried removing the reference using the References collection
to delete the reference?

Although this little one-liner will error if you try to single step it, it
does work when simply run:

References.Remove References.Item("YourReferenceName")

Good luck.

Sco