• What is the deal with VB references? (Access 2002)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » What is the deal with VB references? (Access 2002)

    Author
    Topic
    WStmorken
    AskWoody Lounger
    May 13, 2003 at 6:22 pm #387453

    Shouldn’t VB references register automatically? It seems that they aren’t In nwer versions of a database (a few weeks). there are references showing in older versions that are not showing in new versions. Theses are being run under the same software on the same computer. Some of the references are not even on the list in the newer version, but do show up in the older version. Anyone know what is going on with this?

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WScharlotte
      AskWoody Lounger
      May 13, 2003 at 7:04 pm #676237

      Perhaps if you get specific instead of just referring to “references” in general, someone will be able to give you an answer. If you’re talking about DAO references, they don’t turn up as selected in Access 2002 databases unless you set them. ADO is the default, period, unless you are converting from an earlier version that has the DAO reference set.

      Reply | Quote
      • WStmorken
        AskWoody Lounger
        May 13, 2003 at 7:19 pm #676244

        The references I am referring to are the ones under the tools menu in the VB window for an access form module. There is a long list of references that I assume are found by Access when opening. Some are already checked off (ie, referenced). But the list is inconsitent between different copies of the same front end – some references are missing and some are already checked on one version but not another. It seems to be a problems with Access finding the right references for it’s needs.

        Reply | Quote
        • WScharlotte
          AskWoody Lounger
          May 13, 2003 at 8:11 pm #676261

          The list itself is largely irrelevant and comes mostly from the registry. The only significant items are the ones checked or any that show MISSING ahead of the name. Everything else varies by version of Access, other installed applications, and what profile everything was installed in. Access doesn’t need 99% of the references it finds and can’t use the bulk of them anyhow. If some of them show “MISSING”, rather than just being missing from the list, you have a reference problem in that particular database. Usually that means that the library file is not in the location where Access expected to find it. Windows *usually* finds references if they are in the same folder as the application, but even that can break if you install a runtime version of the app in a different location than it was originally on the development machine. Some default file locations have changed between versions of Access too, so that adds to the complexity.

          If you specify the particular references that are of concern to you, someone may be able to help.

          Reply | Quote
    • WScharlotte
      AskWoody Lounger
      May 13, 2003 at 8:28 pm #676269

      This appears to be related to post 253383, which is more specific, so I’m going to lock this thread and ask that any other responses be posted to the linked thread.

      Reply | Quote
    Viewing 1 reply thread
    Reply To: What is the deal with VB references? (Access 2002)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.