Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reference Libraries for 2002 (2003)

    This problem is turning out to be very frustrating and complicated for me and I don

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

    Re: Reference Libraries for 2002 (2003)

    Can you view the code in the Visual Basic Editor while in Access 2003? If so, there should be no problem viewing the code in Access 2002 - I have often opened databases posted by Access 2003 users here in the Lounge in my Access 2002, and set the references back to the 10.0 version.

    Do you have a recent backup of the database before you edited it in Access 2003? It might be easiest to go back to that.

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reference Libraries for 2002 (2003)

    Hans
    Thanks so much for your response...
    I can view the code in 2003 but I have no references to 10.0 in my list, even if I convert to a previous version.
    That's one of the reasons I thought it would work to install 2002 - but if I open the database using 2002 then I can't access the code.
    I created a new database in the 2002 version and I still only have 11.0 and not 10.0.
    I do have a previous version and I have access to the reference library but still have 11.0 in my references and no 10.0 to choose.
    It appears that my reference library is refusing to cooperate with me! Is there some way I can get the 10.0 library on my list?

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

    Re: Reference Libraries for 2002 (2003)

    You won't be able to select a 10.0 reference while you're using Access 2003. You must do so in Access 2002, but of course, you must be able to view the Tools | References dialog to do so. Then, the 11.0 references will show as MISSING. You can clear them and set the corresponding 10.0 references. Again, you MUST do this from Access 2002.

  5. #5
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reference Libraries for 2002 (2003)

    Hans
    That is one of my problems. If I open Access 2002 and view the Tools | References, 11.0 is NOT missing and I do not have ANY references to 10.0 in the list. Just to be sure I'm in 2002, I checked 'About Microsoft Access' and the Version is Microsoft Access 2002 (10.2627.2625).

    PS - I hope I'm not reading like a condescending idiot. I guess I'm just not communicating my problem very well. I never was very good at explaining things in writing, especially when I don't really feel like I know enough to write intelligently about it. I can't put my frustrated tone into an e-mail. Is there an emoticon for frustration?? :-(

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reference Libraries for 2002 (2003)

    Have you re-install Office or Access 2002 without removing the 2003 version ?
    I think this could be the problem.
    See Information about running multiple versions of Office with Office 2003
    Francois

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

    Re: Reference Libraries for 2002 (2003)

    > I hope I'm not reading like a condescending idiot

    Not at all. I can understand your frustration. If you click Smilies above the editing area, you'll find lots of smilies to convey all kinds of emotions, for example <!t>[brickwall]<!/t> <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    If you see references to 11.0 libraries in Access 2002, and no references to 10.0 libraries, there may be something wrong with the way Access was installed. A complete uninstall of both versions, then a reinstall of first Office 2002, then Office 2003 in a different folder would be needed. For the moment it is probably easier to log in on a machine with only Access 2002.

  8. #8
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reference Libraries for 2002 (2003)

    Thanks to you and to Francois for your help. Since I'm on a network I have to wait for someone else to do this - but I have requested an uninstall of 2003, and then install 2002, then 2003. I'm only telling you this because I'm not sure how long it will take. I didn't want to just ignore you - and if this doesn't work then I'm going to come cry on your shoulder again..... I will let you know if it works, so if anyone else has this problem they might have a solution...

    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> <img src=/S/bwaaah.gif border=0 alt=bwaaah width=123 height=15> (and all related smilies... thanks again, Hans)

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

    Re: Reference Libraries for 2002 (2003)

    We've been through a similar scenario recently with 2003 and 2000. Generally what you can do in 2003 is remove the reference to a specific object, then add a reference to the older version by finding the same file name in a different directory, and be careful not to compile the VBA project. Then you can usually take it to the older version PC, open the VBA project and then compile it and all is happy. I have however seen one situation where that did not work, and we had to resort to a backup of the project. Another strategy that sometimes works is to create an empty database and then import all of the objects from the 2003 database, and add references as necessary after that has been done.

    Note that the prior advice to install 2002 first, and then install 2003 should be done in any event.
    Wendell

Posting Permissions

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