Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't create duplicate queries (97 SR2)

    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.

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

    Re: Can't create duplicate queries (97 SR2)

    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.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't create duplicate queries (97 SR2)

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

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

    Re: Can't create duplicate queries (97 SR2)

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

  5. #5
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't create duplicate queries (97 SR2)

    Thank you anyway, will keep looking.

  6. #6
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't create duplicate queries (97 SR2)

    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.

Posting Permissions

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