Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2009
    Location
    Rye, Victoria, Australia
    Posts
    150
    Thanks
    8
    Thanked 0 Times in 0 Posts

    My VBE6EXT.OLB file is missing!

    Hello, again, Colleagues All,

    My current PC runs Office 2010 and Access 2010 under Windows 7. My laptop runs Office 2003, Access 2003 under Windows XP.

    I have copied some databases from my laptop to my PC, with the intention of upgrading them to the latest and greatest. However, whenever I try to open a database (in the expectation it will ask me if I want to upgrade it), the only responses I get are (i) a VBA box with the message "VBE6EXT.OLB cannot be loaded" or (ii) a similar box with the message "Your network access was interrupted. To continue, close the database and then open it again.". I have Googled the file name, but have received a lot of conflicting advice (probably because the error happens under all sorts of conditions). I also created a new database, but when I click on the VBA tab in the ribbon, there is no response at all.

    I am getting a bit stressed over this one, as a client, for whom I developed a database about five years ago, and who, on the advice of a manager, replaced it with a commercial system, rang me up out of the blue and said he was ditching that one and wanted to restart development of the old system.

    Any advice gratefully received.

    Jim.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Jim,

    That file should be located at: C:\Program Files (x86)\Common Files\microsoft shared\VBA\VBA6\.
    I don't know if you had an eariler version of Office installed on that machine or not. The machine where I checked it is running Win 7 64 Bit SP-1 with Office 2010. However, I did previously have Office 2003 on that machine so it could be a leftover. One thing you could try is unchecking the Reference to the VBE Extensibility Library on the machine with 2003 installed then move it to the machine with 2010 installed and see if you still have the problem.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    2 Star Lounger
    Join Date
    Jan 2009
    Location
    Rye, Victoria, Australia
    Posts
    150
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Thanks, RG. After posting my inquiry, I had a look around and did indeed find the file exactly where you said it should be, which of course makes the matter even more mystifying. However, alongside the VBA6 directory, there is also a VBA7 directory, which contains a file VBE7.dll and a directory 1033. The latter contains a file VBE7INTL.dll and a number of .CHM files which I understand are compiled HTML files, though I do not know what role they play. So my question is now; if the current version is VBA6, how come it cannot find the .OLB file and if it is VBA7, why should it care ???

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Jim,

    I had another idea while waiting to get to sleep last night. You might try re-registering the file using regserv32.
    I also have the VBA7 directory on my machine. My guess is that 2010 is still using some of the old files.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    2 Star Lounger
    Join Date
    Jan 2009
    Location
    Rye, Victoria, Australia
    Posts
    150
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Thanks again, RG. It is inspiring that your problem does not leave you alone, even when you are trying to retreat from this world/

    Here is the command I ran to try and re-register the file.

    regsvr32.exe C:\Program Files (x86)/Common Files\microsoft shared\VBA\VBA6\VBE6EXT.OLB

    I got an error message saying that it did not recognise the file Program! I assume from this that the program is so old that it does not recognise spaces in file names. I might do a scan of the registry and see if I can find a reference to this danged file.

    Jim

  6. #6
    2 Star Lounger
    Join Date
    Jan 2009
    Location
    Rye, Victoria, Australia
    Posts
    150
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Mysteriouser and mysteriousr!

    I found a very useful advisory site run by Allen Browne and found I should have enclosed my command in quotes.


    When I ran it again, regsvr32.exe found the file, but came up with this message:


    " The module blahblahblah/VBE6EXT.OLB was loaded, but the entrypoint DllRegisterServer was not found. Make sure that blahblahblah/VBE6EXT.OLB is a valid .dll or .ocx file and try again".

    I created a new blank database in Access 2010 and then tried to open VBA. It came up with the same message as previously, i.e. VBE6EXT.OLB cannot be found. If VBA7 is installed, why is it still looking for the older .OLB file. Scream/tear hair/bang head on wall/grab wine bottle form fridge/open and take large swig. Ahhhh, that's better!


    Jim

Posting Permissions

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