Problem with referencing

Posted on 2007-10-01
Last Modified: 2008-07-03
I have a database that I will need to distribute to several people.  I have come to find out that each user will have either Access2000 up to Access2007.  Problem arises when I am referencing an excel library.  Is there a way to check to make sure that their excel library is check marked in the references?
Question by:hpfam
    LVL 119

    Accepted Solution

    LVL 77

    Expert Comment

    To cope with any version of XL you need to use late binding, not early binding.
    There is too much to say than can be said here but here is a link@:
    Using late binding you do not set object references, but that means you cannot use any of the built-in xl constants unless yiou define them as public variables/constants in your code.

    Access will not adjust object library refs for non-access libraries.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now