setting references in code

[Jesper F]

I'm developing a db on my computer access 2k2 that the Microsoft Graph 11
object but I deploy the db on a access 2K machine. It only has the ms graph
10 object and I get a missing reference error until I manually correct the
reference to the graph 10 object and things work.
Can I set the graph 10 object reference through code so that the db will
work on the other machine without manual intervention?
Thanks.

Jesper

 

[Douglas J. Steele]

You can set references in code using the AddFromFile or AddFromGUID methods
of the References collection (see, for example,
http://msdn.microsoft.com/library/en-us/vbaac11/html/acmthCreateFromFile_HV05186713.asp)
but I'd recommend using Late Binding instead, so that you don't need a
reference.

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