GP 7.5 PC Permissions

[ale1981]

I have been in my current position around 4 months and before starting here I had never come across Great Plains before. We run v7.5, which i understand is very outdated now, which doesnt help me at all!

Our client PCs are all Windows XP Pro. We have a fair bit of modified vba and before I arrived, to get this to work the users of the PCs were set as local Administrators on every PC, which you can uderstand was a big security risk. I was advised of some registry mods which solved this problem.

Now we are having a problem where the users can not export from the smartlist to excel or word when they are set as standard users.

Does anybody know how I can get around this? Is there any other registry mods I can do. We were thinking of upgrading to GP 9.0 but I have been advised by our head office we may be moving to different software shortly.

Appreciate any replies.

Thanks in advance.

 

[jazgeek]

I do believe there's a temp directory that you need to grant full permissions on. Can't remember it exactly but I'm sure if you run local admin and trace where the temp directory is outputting you can work with that.



-----------
and they wonder why they call it Great Pains!

jaz

 

[VictoriaYudin]

Is exporting to Excel from SmartList in GP the only thing you're having an issue with? Nothing else in GP? If so, most likely you won't be able to fix this with permissions because it has to do with how Excel was installed. There are two things we typically try for this:

1. Log into the computer as the local administrator. Run Excel. Log back in as a regular user and see if it now works. Once in a while this fixes it, but typically not.
2. Reinstall Excel while logged into the computer as the local administrator. (Do a complete install of all the Excel components.) While still logged in as the local administrator run Excel, it should ask you to initialize it. Log back in as the regular user and see if it now works.

A few notes:
- It's been a while since we worked with GP 7.5, but I am fairly certain that you can get away without having to make users admins. Certainly in GP 9.0 you are able to do so.
- No matter what, GP users need to have full control of the entire GP directory.
- When I say the local admin, I mean THE local admin, not just a user who happens to be a local admin.
- Sometimes, if GP is not installed and first run as the local admin it also causes issues, but that is less common.

Hope that helps.

Victoria
Flexible Solutions, Inc.

 

[RobertC22]

When I used to install Great Plains 7.5 on XP/2000 I did a Smartlist export whilst still logged in as administrator so that the required registry settings got created.

The normal logged on user could then do Smartlist exports after that.

There is no KB article that I have ever come across that tells me the registry keys necessary for this, hence the above workaround.

------
Robert

 

[VictoriaYudin]

Robert,

I believe running Excel when logged in as the local administrator accomplishes the same thing, creating the needed registry keys.

Victoria
Flexible Solutions, Inc.