Missing References in Access when using DB on different user's machines
Posted on 2011-05-01
Hello, I'd be interested in hearing from some of the experts here who manage databases on a topic that has been frustrating me a little bit. In many of the databases I'm using, VBA coding requires that I create references to different .dll files. However, on some user's machines they will not have the appropriate dll available (such as msoutls.dll). These usually just requires a small amount of tweaking and removing these references to get the database to run smoothly, albeit without that feature.
My question is, aside from having identical workstations, what steps can I take to prevent these types of errors, if any? What sort of practices do you advanced users go through when setting up a database that could be used on a variety of user's machines?
Thanks so much as always for the comments,