missing reference

[Guest]

When I'm doing some changes (VB code, etc.) in a shared DB on my computer and
save it and open the DB on another computer the VB code is being opened
pointing out on an error. This error is associated with a missing reference.
For example, if I have on my computer Microsoft Excel 11.0 Object Library
but on another computer it's just Excel 9.0 the Excel 11.0 reference will be
missing on that computer. To fix it I need to open References on that user's
computer and re-set up it to Excel 9.0.

But, when I make any changes and save them through my computer it'll happen
again.

How could I resolve it?

Thanks

 

[Douglas J. Steele]

You could try using Late Binding, so that you don't need to set a reference
at all.

Tony Toews has an introduction at
http://www.granite.ab.ca/access/latebinding.htm

If you need more help after that, post back!