Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Missing vba332.dll (WINXP/Access 2003 SP-1)

    I have the challenge (headache) of converting all of our databases from Access 97 to Access 2003.
    So far, it hasn't been too bad, until I got this error trying to open one of the databases:

    [i][b]Runtime error

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

    Re: Missing vba332.dll (WINXP/Access 2003 SP-1)

    I have 3 pc, one with Office 2003, one with Office 2000 and one with Office97.
    On the pc with Office 2003, I do not have this file. (Full install)
    On the pc's with Office 2000 and 97 I find the file in the directory :
    C:Program FilesCommon FilesMicrosoft SharedVBA

    On my Office 97 SP1 cd I find the file in :
    cdDriveLetter:OSSystemVBA332.DLL
    It has the same size (1.560KB) and the same modified Date (08/01/1997)
    Maybe you can just copy it and see what happens ?
    Francois

  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 vba332.dll (WINXP/Access 2003 SP-1)

    What is using that in your code? 2003 (along with 2000 and 2002) uses an entirely different development environment from 97 so I seriously doubt that you want or need that file on your PCs. It is the VBA reference for 97 and you would be better off finding the code that uses it if any, and updating it to use the current equivalent, which I believe is VBE6.dll.
    Charlotte

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

    Re: Missing vba332.dll (WINXP/Access 2003 SP-1)

    Adding to the discussion, you might benefit from the conversion toolkit released by Microsoft a couple of months ago. If you have lots of databases to convert, it is a very handy tool.
    Wendell

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing vba332.dll (WINXP/Access 2003 SP-1)

    <hr>What is using that in your code<hr>
    After reviewing the database once again, I have discovered (remembered) that I was using code to prevent the mouse scroll.
    For those interested, here is the code that did prevent the mouse scroll when I was using WINXP and Access '97.
    (We are going straight to Access 2003)

    Long piece of code (almost 3,000 characters) moved to attachment by HansV

    By moving the vba332.dll, I was able to OPEN the database, but the code to prevent the scroll does not work.
    I am in the process of trying 2003 code to accomplish this.

    I hope this helps someone else !

    Michael

  6. #6
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing vba332.dll (WINXP/Access 2003 SP-1)

    Thank you Hans.

    Wendell - I am having my IT people get their hands on the conversion kit. Thank you for the heads up !

    Michael

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

    Re: Missing vba332.dll (WINXP/Access 2003 SP-1)

    FYI, it was released coincident with SP1 for Office 2003 - you can read a brief review of it here.
    Wendell

  8. #8
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing vba332.dll (WINXP/Access 2003 SP-1)

    Thank you for that Wendell - it's a good read.

    We have the conversion kit now and are in the process of utilizing it.

    Have a good weekend !

    Michael

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

    Re: Missing vba332.dll (WINXP/Access 2003 SP-1)

    No, I wouldn't expect it to. VBA332.dll was based on VB5. Office 2000 and later are all based on VB6, so you won't be able to just copy a dll and make that kind of thing work.
    Charlotte

Posting Permissions

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