Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Rockledge, FL
    Posts
    327
    Thanks
    23
    Thanked 11 Times in 11 Posts

    Converting Access97 to Access XP (Access 2002 (10.2616.2625))

    I have just installed W2000, SP3 with Office XP on my wife's PC. When converting some of her small databases I get the following error:

    Missing or broken VBE reference to the file 'dao2535.tlb

    Does anyone know what this message really means and how to fix it ?

    Thanks

    Kevin

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting Access97 to Access XP (Access 2002 (10.2616.2625))

    Can you check the References and see if you have a DAO reference selected? In XP, I need to select the DAO 3.6 library in order to run DAO.

    HTH,

    Cecilia :-)

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Rockledge, FL
    Posts
    327
    Thanks
    23
    Thanked 11 Times in 11 Posts

    Re: Converting Access97 to Access XP (Access 2002 (10.2616.2625))

    I checked under the Tools menu in Access XP but did not see any option to References. Is this where you were talking about ? (I do see some references to that topic in the Help system ...just don't see it in the menu structure. I am running Office XP under W2000, SP3...maybe this makes a difference ?

    Kevin

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting Access97 to Access XP (Access 2002 (10.2616.2625))

    If you open a module (or create a blank one, just so you can get to this menu), the References selection will be under Tools.

  5. #5
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Rockledge, FL
    Posts
    327
    Thanks
    23
    Thanked 11 Times in 11 Posts

    Re: Converting Access97 to Access XP (Access 2002 (10.2616.2625))

    That is where I looked. It seems that with Office XP installed under W2000 (maybe) that there is no references menu item under the Tools menu heading.

    Kevin

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Converting Access97 to Access XP (Access 2002 (10.2616.2625))

    You actually need to have the module open in design mode in order to see the References option - it is under the Tools menu in the VBA editor.
    Wendell

  7. #7
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Rockledge, FL
    Posts
    327
    Thanks
    23
    Thanked 11 Times in 11 Posts

    Re: Converting Access97 to Access XP (Access 2002 (10.2616.2625))

    Even with the table open in design mode, there is no REFERENCES item under the TOOLS menu.

    Kevin

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Converting Access97 to Access XP (Access 2002 (10.2616.2625))

    None of this has to do with tables - it must be a Module - you cannot view modules in the database container window, it must be in the VBA editor.
    Wendell

  9. #9
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Rockledge, FL
    Posts
    327
    Thanks
    23
    Thanked 11 Times in 11 Posts

    Re: Converting Access97 to Access XP (Access 2002 (10.2616.2625))

    OK, got it. Guess I have never been into VBA under Access before <g>. Thanks for the tip!

    Kevin

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

    Re: Converting Access97 to Access XP (Access 2002 (10.2616.2625))

    Just to jump into this discussion late (I was out of town), the library you mentioned in the beginning is a compatibility library that I don't recommend using. It was originally there to allow Access 2.0 (AccessBasic) code to run under Access 95 and later (VBA), but it's a bad habit to use compatibility libraries unless you absolutely have to because your programming doesn't keep up with the language and eventually won't be supported at all.
    Charlotte

  11. #11
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Rockledge, FL
    Posts
    327
    Thanks
    23
    Thanked 11 Times in 11 Posts

    Re: Converting Access97 to Access XP (Access 2002 (10.2616.2625))

    OK, thanks for the reasoning behind that. I have has my names and addressses in Access since Access 1997. So, I presume that was how it got in there in the first place. I don't remember specifically using that library.

    Thanks again,

    Kevin

Posting Permissions

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