Thursday, March 27, 2008
So, a user by the name of 2020 asked on the newsgroups the other day, how can we disable outlook on the Great Plains home page?

I happen to have had this same issue and using my trusty SQL Profiler, I found that when I manually uncheck Outlook from my home page, GP ran a SQL statement like the following :


UPDATE DYNAMICS.dbo.SY08100
SET Visible = 0
FROM DYNAMICS.dbo.SY08100
WHERE COLNUMBR = 1
AND SEQNUMBR = 3
AND Visible = 1
AND USERID = 'dpatrick' -- comment this if you want to do it for all users
AND SectionID = 2

This works great, but it doesn't actually stop any particular user re-checking Outlook on the home page (but it got me what I wanted, which is to default Outlook to being off for everyone).

Dave Musgrave, from Microsoft, later chimed in and gave us this link:

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;918313

which discusses how to actually disable Outlook from the homepage (and uses a script that looks pretty close to the one I use).

Good stuff!

Thanks Dave and thanks 2020 for asking the question!

2 comments:

Jeffrey said...

Very helpful. Not everyone using Dynamics here has outlook so the profile prompts when starting dynamics were annoying. Nice easy way to kill outlook for everyone. Thanks for the tip,

Alex said...

To my mind exist some groups of softwares for resolving other king of compter problems. But one day all these principles I forgot, because my emails were deleted on undetermined cause. I tried to use the Google and successfully unearthed one utility for solving this problem. It setlled my troubles for seconds and I count it would aid in this issue also - exchange restore from ost file.