missing references (1 Viewer)

[dreamdelerium]

hey all,
when i put my access database on a computer other than the one i developed it on, it complains about a missing reference (Microsoft office 12 object library). the older computers only have Microsoft office 11 object library.

how do i add a reference to Microsoft office 11 object library at startup if it doesnt have Microsoft office 12 object library reference?

thanks
jason

 

[Rabbie]

That's because you are using Early Binding. Use Late Binding if you have many computers with different versions of Office. Alternatively fix the references manually.

There have been several threads on this recently so try searching the forum for more info.

 

[RuralGuy]

Here's a couple of links that may be useful:
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
http://www.granite.ab.ca/access/latebinding.htm