Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Oh no! The VB stopped functioning in my database! (O2K, SR-1)

    I made some changes to the VB code for a form I was working on. I don't know what I did, or if it just corrupted on me, but now anytime VB is called anywhere in my database, I get the error "Error accessing file. Network connection may have been lost". Even when I initially open the database that error pops up twice and then the system switches me over the the VBA window. Any ideas?
    THANKS!

    Angela <img src=/S/drop.gif border=0 alt=drop width=23 height=23>

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

    Re: Oh no! The VB stopped functioning in my database! (O2K, SR-1)

    Did you, by any chance, install any of the Office XP components on your Machine, including Visio 2002 or Publisher 2002? There's a bug in Access 2000 (although how they can say that when the later version is what breaks it escapes me) when it interacts with the version of the VBE that installs with 2002. There's supposed to be a hotpatch coming out any day, but it hasn't been publicly announced yet that I've heard of. <A target="_blank" HREF=http://support.microsoft.com/default.aspx?scid=kb;EN-US;q304548>Here's</A> a link to the MSKB article on it.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Oh no! The VB stopped functioning in my database! (O2K, SR-1)

    That's probably it; I did have Office XP installed on my PC for a while as a test. I've requested a copy of the file from our backup tapes. Do you think I can do what the article suggests (compile the database from the VB Editor before closing the database) and avoid this issue, even though my scenario isn't exactly the same?

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

    Re: Oh no! The VB stopped functioning in my database! (O2K, SR-1)

    It's worth a try, but unless you rename the VBE6.dll and reinstall Office 2000. it's likely to crop up again. My Access 2000 hasn't been the same since I installed and then uninstalled Access XP ... in spite of reinstalling Office 2k without taking that extra step. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Oh no! The VB stopped functioning in my database! (O2K, SR-1)

    OK, so what if I re-install Access 2002 and do my development for the database from there?

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

    Re: Oh no! The VB stopped functioning in my database! (O2K, SR-1)

    That's what Microsoft recommends. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> Of course, that means you can't see how the database will behave in Access 2000 .... <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    Charlotte

  7. #7
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Oh no! The VB stopped functioning in my database! (O2K, SR-1)

    Dang! Well, thanks very much for your help! <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

  8. #8
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Oh no! The VB stopped functioning in my database! (O2K, SR-1)

    Charlotte,
    Is there a good way to find out when (if?) they do put out a hotpatch for this issue, as soon as it's available?
    Thanks,
    Angela

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

    Re: Oh no! The VB stopped functioning in my database! (O2K, SR-1)

    Keep watching the Office Update site and keep an eye posted here in the Lounge. I'm supposed to be notified once the thing is available to the public and I'll let everyone know. They made a download available to those of us who had screamed the loudest, although I haven't been willing to test it just yet, so <img src=/S/scream.gif border=0 alt=scream width=15 height=15>ing at them might help as well. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> Try going to on-line support and posting a message there.
    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
  •