Can’t create duplicate queries (97 SR2)

Topic

New Reply

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

Replies

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

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

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

Reply | Quote

Thank you anyway, will keep looking.

Reply | Quote

Thank you anyway, will keep looking.

Reply | Quote

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

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

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

Reply | Quote

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

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