Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

Problem with referencing

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?
1 Solution
Rey Obrero (Capricorn1)Commented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now