Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Missing reference/link (XP)

    I have a database that I am trying to open and I finally learned how to do it by pointing to the appropriate

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing reference/link (XP)

    The DAO2535.tlb is a compatability library, the other one is probably some kind of utility or resource database used by the developer.

    Open the database with the left shift key held down (to bypass automatically starting code).
    Activate the Visual Basic Editor (Alt+F11).
    Select Tools | References...
    You will probably see tow references starting with MISSING.
    Clear the check boxes for these references.
    Click OK.
    Select Debug | Compile <name>
    If you get an error message about a user-defined type not being declared, select Tools | References... again.
    If Microsoft ActiveX Data Objects 2.n Library is checked, clear the check box.
    Scroll down the list and locate Microsoft DAO 3.6 Object Library.
    Check this item, then click OK.
    Try Debug | Compile <name> again.
    If you still get error messages, write them down and post back.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Missing reference/link (XP)

    The reference XP needs is DAO 3.6. The old DAO compatibility library was for using antiquated code instead of learning the newer features of VBA. If you uncheck that and add a reference to DAO 3.6, you'll be able to identify coding problems when you compile. The other reference is to an Access database, which may have been an add-in or code library. If you don't have such an animal, remove the reference. Again, a compile will tell you what's missing or broken when those references are changed.
    Charlotte

  4. #4
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing reference/link (XP)

    Thanks.. when i change to DAo 3.6 & recompile I get a compile error: sub or function not defined. And the text is highlighted as shown below.

    Public Sub ConfigureAddIns()

    If (ODI_GetDatabaseProp("AddInesi")) = True Then

    <span style="background-color: #FFFF00; color: #000000; font-weight: bold">Call linktablesbilling</span hi>

    If err <> 0 Then
    MsgBox "Could not link Billing Tables", vbExclamation, "Error"
    ODI_SetDatabaseProp "AddInesi", "0"
    End If

    End If

    End Sub

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Missing reference/link (XP)

    Did someone send you this database? If so, you're missing some of the parts. The function it's breaking on was probably in the mdb you don't have, which was most likely a code library.
    Charlotte

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing reference/link (XP)

    Hi Don,

    Just to make sure, search through the entire VB project for something resembling a definition of linktablesbilling. If you can't find it (and I fear you won't), it must be a procedure or function in the missing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •