Wizards do not work under XP for users with restricted security

zorplex

New member
Local time
Today, 23:45
Joined
Feb 18, 2005
Messages
7
The problem occurs on a WinXP machine with Access 97.

When Access is run as a Power User everything works fine but when it runs under a user account that is a standard "User" non of the wizards function properly.

By changing some file permissions I can get the control, form and report wizards to work but the Import Data wizard still fails.

I'm sure this is a permissions issue and can be fixed by changing the security settings for some registry keys or files, but have no idea which ones.

Thanks in advance for any help.
 
Solution: Access 97 and XP file permissions

Found a solution to the problem myself which I thought I'd post for the sake of completness.

To enable charting, form and report wizards give the user's account write prmissions to the Microsoft Office folder (it seems to create temporary files here files during the wizard process)

To enable the data wizards use regedt32 to give the user full control permisison to the Microsoft Office 8 set of keys.
HKLM\Software\Microsoft\Office\8.0

I also found the official solution to the problem on Microsoft's web site, which says:

"This behavior occurs because Microsoft Access 97 does not run in a Restricted account. SOLUTION: Upgrade Access 97 to Microsoft Access 2002"

which just goes to show how little effort they put into finding a solution.

.z
 

Users who are viewing this thread

Back
Top Bottom