• Can’t create duplicate queries (97 SR2)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Can’t create duplicate queries (97 SR2)

    • This topic has 10 replies, 2 voices, and was last updated 21 years ago.
    Author
    Topic
    WSamacs
    AskWoody Lounger
    May 14, 2004 at 12:51 am #404894

    We have Access 97 installed on an WinXPPro PC and the user is a power user. The problem is the user cannot create duplicate queries. An error comes saying it is not installed and to rerun the Office install to add the find duplicates query wizard. However, if an admin logs onto the PC they can create duplicate queries. This error has been duplicated on another PC with the same set up. I do not want to make the user a local admin as I know he will abuse the privelege. IS there any other way to give user permission to be able to create duplicate queries.

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WScharlotte
      AskWoody Lounger
      May 14, 2004 at 12:59 am #827015

      It’s the query wizard that isn’t installed properly for that user. Have the Admin do a reinstall of Office and make it available for all users on that machine, not just the current user.

      Reply | Quote
      • WSamacs
        AskWoody Lounger
        May 14, 2004 at 1:24 am #827025

        When I run the install I am not asked to make it available to all users. Is there another way to do this.

        Reply | Quote
        • WScharlotte
          AskWoody Lounger
          May 14, 2004 at 2:36 am #827053

          Access 97 is the only 97 app I still have installed, so I don’t know what to suggest.

          Reply | Quote
          • WSamacs
            AskWoody Lounger
            May 14, 2004 at 2:45 am #827055

            Thank you anyway, will keep looking.

            Reply | Quote
          • WSamacs
            AskWoody Lounger
            May 14, 2004 at 2:45 am #827056

            Thank you anyway, will keep looking.

            Reply | Quote
          • WSamacs
            AskWoody Lounger
            May 14, 2004 at 5:02 am #827067

            I have worked it out. There are 3 files that relate to the Access add-in wizard and the tools for the duplicate and other queries. They are; wztool80.mde; wzmain80.mde; wzlib80.mde. The user only had read & execute permission on these files. Changing them to full control solved his problem.

            Reply | Quote
          • WSamacs
            AskWoody Lounger
            May 14, 2004 at 5:02 am #827068

            I have worked it out. There are 3 files that relate to the Access add-in wizard and the tools for the duplicate and other queries. They are; wztool80.mde; wzmain80.mde; wzlib80.mde. The user only had read & execute permission on these files. Changing them to full control solved his problem.

            Reply | Quote
        • WScharlotte
          AskWoody Lounger
          May 14, 2004 at 2:36 am #827054

          Access 97 is the only 97 app I still have installed, so I don’t know what to suggest.

          Reply | Quote
      • WSamacs
        AskWoody Lounger
        May 14, 2004 at 1:24 am #827026

        When I run the install I am not asked to make it available to all users. Is there another way to do this.

        Reply | Quote
    • WScharlotte
      AskWoody Lounger
      May 14, 2004 at 12:59 am #827016

      It’s the query wizard that isn’t installed properly for that user. Have the Admin do a reinstall of Office and make it available for all users on that machine, not just the current user.

      Reply | Quote
    Viewing 1 reply thread
    Reply To: Reply #827067 in Can’t create duplicate queries (97 SR2)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




    Cancel
DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.