Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I access a module to fix a missing or broken reference?

Discussion in 'Information Technology' started by M.T. Blanch, Jul 28, 2006.

  1. M.T. Blanch

    M.T. Blanch
    Expand Collapse
    Guest

    I am receiving a message that I have a missing or broken reference in file
    "doa2535.tbl" ver 3.5. I cannot find the reference after accessing the
    Visual Basic Editor under "Macro" under "Tools" within my data base. I
    cannot find any other way to view a "reference". I cannot find this file
    when performing a search of the hard drive. How do I fix this?
     
  2. Loading...


  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    What version of Access are you using? dao2335.tbl is a compatibility layer
    that only works in Access 97. Odds are you should have a reference to DAO
    3.6 instead.


    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "M.T. Blanch" <M.T. Blanch@discussions.microsoft.com> wrote in message
    news:B67BC1F8-E6DE-4045-B555-ABB312C12BE0@microsoft.com...
    >I am receiving a message that I have a missing or broken reference in file
    > "doa2535.tbl" ver 3.5. I cannot find the reference after accessing the
    > Visual Basic Editor under "Macro" under "Tools" within my data base. I
    > cannot find any other way to view a "reference". I cannot find this file
    > when performing a search of the hard drive. How do I fix this?
     
  4. M.T. Blanch

    M.T. Blanch
    Expand Collapse
    Guest

    Hi Douglas,
    I am using Access 2003 but this database was orginally created in Access 97
    and converted. The error message tells me this .tbl file is in version 3.5
    Any ideas? Most of this terminology is way over my head!
    Thanks for answering.
    M.T. Blanch

    "Douglas J. Steele" wrote:

    > What version of Access are you using? dao2335.tbl is a compatibility layer
    > that only works in Access 97. Odds are you should have a reference to DAO
    > 3.6 instead.
    >
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Open the VB Editor (Alt-F11)

    Select Tools | References from the menu.

    If any of the checked entries at the top of the list have MISSING: in front
    of them, uncheck them (write down what they were, just in case...)

    Go to the Debug menu, and select the Compile option. If you get no errors,
    you should be done.

    If you do get errors, pay attention to what the errors are. If they're
    complaining about "user defined type" for declarations that dimension
    variables to As Database, go back into the References dialog, scroll through
    the list of available references until you find Microsoft DAO 3.6 Object
    Library and select it. Do your Compile again.

    If that doesn't solve the problem, report back what it's complaining about.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "M.T. Blanch" <MTBlanch@discussions.microsoft.com> wrote in message
    news:5155C65E-0C26-434B-AAA5-F6F2F1388066@microsoft.com...
    > Hi Douglas,
    > I am using Access 2003 but this database was orginally created in Access

    97
    > and converted. The error message tells me this .tbl file is in version

    3.5
    > Any ideas? Most of this terminology is way over my head!
    > Thanks for answering.
    > M.T. Blanch
    >
    > "Douglas J. Steele" wrote:
    >
    > > What version of Access are you using? dao2335.tbl is a compatibility

    layer
    > > that only works in Access 97. Odds are you should have a reference to

    DAO
    > > 3.6 instead.
    > >
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no private e-mails, please)

    >
     

Share This Page