Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    May 2002
    Location
    Massachusetts, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access add ins (2000 sr-1)

    I have Access 2000 installed on 2 machines. One is NT 4.0, sp6; the other is Win2k. On both machines, all mde add-ins are "locked." The file icons in Explorer have little blue padlocks on them, and they won't install. I'm in a corporate environment, and everyone at the "help" desk is stumped. Any clues?

    Thanks,
    Melanie

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

    Re: Access add ins (2000 sr-1)

    What kind of add-ins are you talking about? Are these something built in house, or are they purchased add-ins or part of Office? Do you have any kind of security or virus control software that prevents you from installing add-ins on those machines? Can you install them on other machines?
    Charlotte

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

    Re: Access add ins (2000 sr-1)

    Actually all *.mde files get the Access icon with a little blue padlock in the upper right corner - that's the default icon assignment. I don't understand what you mean by "they won't install" - an mde is a compiled version of an Access database that won't let you make design changes to forms, reports and code. What sort of error messages are you getting?
    Wendell

  4. #4
    New Lounger
    Join Date
    May 2002
    Location
    Massachusetts, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access add ins (2000 sr-1)

    The addins in question are the standard ones that come with Access: ACWZMAIN.MDE, ACWZTOOL.MDE, & ACWZLIB.MDE. The mda file, UTILITY.MDA, has the "lock," too, but seems to have gone in properly. When I say installed, I mean by going to Tools/Add Ins/Add In Manager, and going through the process. It seems to be just these files, as I have successfully added a third party add in with no trouble (Rick Fisher's Find & Replace).

    Last night I tested this at home and found that the locks are there, too. Guess I just never noticed them before. I had better luck adding them at home, but ACWZTOOL still wouldn't go in and hung Access, just like at work. I did manage to capture an error message at home that read: Cannot copy ACWZTOOL: The request could not be performed because of an I/O device error. I got that error trying to copy the file from the 1033 folder to my personal Add Ins folder (which I tried just to see if it was the Add In Manager that was messed up).

    I do have Norton Anti-virus at work and at home. Could that be interfering? (It didn't with Access 97.)

    Thanks, Melanie

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

    Re: Access add ins (2000 sr-1)

    I don't know if the situation is radically different for Access 2000.

    In Access 97, the equivalents of these files contain the "standard" Access wizards; you decide whether they should be installed during installation of Office. They don't appear in the add-in list.

    You should be able to install/uninstall wizards by opening Add/Remove Programs in Control Panel, and selecting Microsoft Office 2000 Professional.

    Also see ACC2000: Nothing Happens When You Try to Start a Microsoft Access Wizard (Q242218).

  6. #6
    New Lounger
    Join Date
    May 2002
    Location
    Massachusetts, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access add ins (2000 sr-1)

    Thanks, this is very helpful. It looks like those components were installed, but at least now I know why I can't do my add-ins the way I've done them in Access 97. Someone told me that Office 2000 gets "snarled up" if anything is installed after it is, which was the case for me. Maybe I just need to reinstall Office entirely.

    Thanks again,
    Melanie

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

    Re: Access add ins (2000 sr-1)

    In Access 2000, there are two different sets of add-ins, those accessed from the UI and those loaded and used from the IDE. Most of the "add-ins" in 97, like the Switchboard manager and Linked table manager are no longer add-ins in 2000. Instead, they're built in and found under the Database Utilities menu.

    Maybe if you explain what you're actually trying to accomplish, someone can help. The only add-ins you should have to "install" (that is, load) are in the IDE.
    Charlotte

  8. #8
    New Lounger
    Join Date
    May 2002
    Location
    Massachusetts, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access add ins (2000 sr-1)

    Originally, I was trying to import an Excel spreadsheet. It looked like it was going to fire up the wizard (the status bar said Import Spreadsheet Wizard), but the dialog box never appeared and Access got hung up. I could do other functions, but in order to close out of Access, I had to use End Task. I remembered that in Access 97, I'd had to use the Add In Manager for imports and some advanced queries, so I went through the add in process I'd done back then. It didn't work, and that's what prompted my original post. (I haven't had any trouble with the components under Database Utilities, btw. They work just fine.)

    Since your last reply, I've checked to see what was included in the original installation of Office 2000, and all the components were there. Office has been reinstalled and that didn't fix it.

    Melanie
    p.s. Sorry - what's the IDE?

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

    Re: Access add ins (2000 sr-1)

    IDE=Interactive Development Environment. In other words, the Visual Basic Editor.
    Charlotte

  10. #10
    New Lounger
    Join Date
    May 2002
    Location
    Massachusetts, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access add ins (2000 sr-1)

    Ah, thanks.

    Office 2000 has been completely uninstalled and reinstalled on my NT machine and the import function (and all others, I think) appears to be working just fine.

    Ghost in the machine? I may never know.

    Thanks for all your input! I have no peer group here; you guys are it. I'm very appreciative of the time and the knowledge you are all willing to share. Maybe someday I'll be able to post an answer to someone's question, and give a little back to the Lounge.

    Melanie <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

Posting Permissions

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