Share
ReportHi there. How can one edit when GP prompts for the SYSTEM PASSWORD ??
Regards,
Peter Muchira
*This post is locked for comments
You’re offline. This is a read only version of the page.
1,910
Hi there. How can one edit when GP prompts for the SYSTEM PASSWORD ??
Regards,
Peter Muchira
*This post is locked for comments
I went through this steps now i am getting an error message stating "your system password file is missing"
Gracious,
It's really not a secret. Go into Report Writer and create a new report with the System Password Master as the base table. Open the report layout and drag the field Password out onto the report. Now, nobody will be able to print it if they are not allowed access to the report via User Security, so it's not an incredible security breach. Even still, I'd print the report in report writer to get the password and then just delete the report.
Mystery solved.
As Far as limiting when the window pops up, you can handle this using VBA. You can cause the window to be answered before it's even displayed. You can, using VBA, even decide which users should get the dialog to begin with.
Kind regards,
Leslie
Hi Richard, i am interested to know as well. could you please email me the solution. kinda stuck with this.
Thank you for the help.
How about writing a macro to open the desired window so that it would automatically type in the password? I know, I know all of the security problems, but I feel certain some crafty IT person could secure that file so that only a specific user can use it. I've had an IT person do something to essentially password the macro file such that they needed a pw to open the macro. You can launch macros from VBA.
It might be as easy as naming it something totally lame that nobody would guess is really a system window.
I'll be we could use the SDT to craft something that could help with this. . . .hmm
Kind regards,
Leslie
Bring back the Palette Pin!!
At this stage it would be a unique selling point!!
Ian.
Back in the good old days when you could 'pin' the menu open this was not a problem. You could open the window. pin it open and it would stay open so you did not have to keep entering the password in over and over again. Then they took they took the pin away and now every time you go to a screen that requires the system password you enter it over and over again. One day I hope the pin comes back but I am not holding my breath. Perhaps they could create a new role called SYSTEM and any user assigned to that role would not be prompted to enter the system password. When you are doing system work and get prompted everytime you go from screen to screen I know how annoying that is.
Guys,
I'm sure only Heather understood my question.
I simply asked how one can override the actual prompting of the system password for some GP processes, say adding new users. Is it possible to bypass the prompt of the system password for some processes and retain the prompt for other processes.
Dont "Fear" johnathan, Warren's method is one way, the second would be creating a Report in RW for it, its on the blogs
:-)
Here is the easy way to reset the password if you dont know it. Assumes that you have Power User role.
1) MS Dynamics GP > Maintenance > SQL
2) Database = DYNAMICS, Product = MS Dynamics GP
3) Select System Password Master as the table
4) Drop the table (that deletes the table)
5) Create the table (recreates the table with a blank password)
You now should be able to proceed to system functions, including establishing a new password.
Warren
David Musgrave posted this solution on his blog years ago. A simple search of the internet will reveal what I have used for years. I have been using Dynamics GP since it first came out on 48 floppy disks. This is no big secret.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (