|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Access Runtime 2002 - User Account permissions error...I have an Access 2002 MDE application that runs under MS WinXP and Access 2002 Runtime. It works great if opened from an Administrator account. However, the following message appears if the db is opened from a user account: "You do not have access to make the required system configuration modifications. Please rerun this installation from an administrators account." I suspected that my application was read/writing somewhere bad (like HKEY_LOCAL_MACHINE), so I created a blank MDE data base... and it too showed the dreaded permissions message above. I next tried adding the user account (with full access permissions) to the registry under HKEY_LOCAL_MACHINE\software\microsoft and HKEY_CLASSES_ROOT/CLSID. That didn't work either. Can Access Runtime be run from non-administrator Windows accounts? If so, how? Thanks in advance for providing any useful information! Hi JayBob
Access Runtime certainly *can* be run from non-administrator Windows accounts. There is a newsgroup thread on a similar subject here: http://groups.google.com/group/microsoft.public.access.multiuser/browse_frm/thread/cedd70b5fa72cc20/2F8bc224c59419ad17 or, if that URL wraps horribly, try this one: http://tinyurl.com/y3ycqt The context there is Windows Terminal Server, but I suggest you search HKLM in your registry for key names including "Access\Resiliency" and try deleting them. Be sure to back up the key first! -- Show quoteHide quoteGood Luck! Graham Mandeno [Access MVP] Auckland, New Zealand "JayBob" <Jay***@discussions.microsoft.com> wrote in message news:8B54F3E7-C67A-4ECA-BABF-2941E2F22E63@microsoft.com... > (banging my head against the wall) > > I have an Access 2002 MDE application that runs under MS WinXP and Access > 2002 Runtime. It works great if opened from an Administrator account. > However, the following message appears if the db is opened from a user > account: > > "You do not have access to make the required system configuration > modifications. Please rerun this installation from an administrators > account." > > I suspected that my application was read/writing somewhere bad (like > HKEY_LOCAL_MACHINE), so I created a blank MDE data base... and it too > showed > the dreaded permissions message above. > > I next tried adding the user account (with full access permissions) to the > registry under HKEY_LOCAL_MACHINE\software\microsoft and > HKEY_CLASSES_ROOT/CLSID. That didn't work either. > > Can Access Runtime be run from non-administrator Windows accounts? If so, > how? > > Thanks in advance for providing any useful information! Hi Graham,
I found one "Resiliency" entry, but it was under HKLM\software\microsoft\Office\10.0\word. I backed up the registry, deleted the entry and then logged out/back in as a user. No soap... Clicking the MDE startup icon (using MSACC runtime) resulted in the same permissions error. Note that the runtime application was installed as Administrator and now I'm running as a user. Could that make any difference? There's an entry under HKLM\software\microsoft\Office\10.0\Access called "InstallRoot" that I haven't noticed before. (I'm grasping for straws here). Show quoteHide quote "Graham Mandeno" wrote: > Hi JayBob > > Access Runtime certainly *can* be run from non-administrator Windows > accounts. > > There is a newsgroup thread on a similar subject here: > http://groups.google.com/group/microsoft.public.access.multiuser/browse_frm/thread/cedd70b5fa72cc20/2F8bc224c59419ad17 > > or, if that URL wraps horribly, try this one: http://tinyurl.com/y3ycqt > > The context there is Windows Terminal Server, but I suggest you search HKLM > in your registry for key names including "Access\Resiliency" and try > deleting them. Be sure to back up the key first! > -- > Good Luck! > > Graham Mandeno [Access MVP] > Auckland, New Zealand > > "JayBob" <Jay***@discussions.microsoft.com> wrote in message > news:8B54F3E7-C67A-4ECA-BABF-2941E2F22E63@microsoft.com... > > (banging my head against the wall) > > > > I have an Access 2002 MDE application that runs under MS WinXP and Access > > 2002 Runtime. It works great if opened from an Administrator account. > > However, the following message appears if the db is opened from a user > > account: > > > > "You do not have access to make the required system configuration > > modifications. Please rerun this installation from an administrators > > account." > > > > I suspected that my application was read/writing somewhere bad (like > > HKEY_LOCAL_MACHINE), so I created a blank MDE data base... and it too > > showed > > the dreaded permissions message above. > > > > I next tried adding the user account (with full access permissions) to the > > registry under HKEY_LOCAL_MACHINE\software\microsoft and > > HKEY_CLASSES_ROOT/CLSID. That didn't work either. > > > > Can Access Runtime be run from non-administrator Windows accounts? If so, > > how? > > > > Thanks in advance for providing any useful information! > > > Hi JayBob
> I found one "Resiliency" entry, but it was under Hmmm... not surprising - that one would have something to do with Word, not > HKLM\software\microsoft\Office\10.0\word. I backed up the registry, > deleted > the entry and then logged out/back in as a user. No soap... Clicking the > MDE > startup icon (using MSACC runtime) resulted in the same permissions error. Access. > Note that the runtime application was installed as Administrator and now No, it shouldn't - that's the way I do all my runtime installations.> I'm > running as a user. Could that make any difference? > There's an entry under No, that's just the folder in which Access has been installed. Every > HKLM\software\microsoft\Office\10.0\Access called "InstallRoot" that I > haven't noticed before. computer with Access installed should have that key. > (I'm grasping for straws here). I'm sorry - I've run out of straws to pass to you! :-/What I'm reasonably sure of is that Access (the program - not your code) is trying to write something to the registry and is failing. You might like to try RegMon or Process Monitor (I think this now includes all the RegMon functionality and has superseded RegMon): http://www.microsoft.com/technet/sysinternals/utilities/processmonitor.mspx -- Show quoteHide quoteGood Luck! Graham Mandeno [Access MVP] Auckland, New Zealand > "Graham Mandeno" wrote: > >> Hi JayBob >> >> Access Runtime certainly *can* be run from non-administrator Windows >> accounts. >> >> There is a newsgroup thread on a similar subject here: >> http://groups.google.com/group/microsoft.public.access.multiuser/browse_frm/thread/cedd70b5fa72cc20/2F8bc224c59419ad17 >> >> or, if that URL wraps horribly, try this one: http://tinyurl.com/y3ycqt >> >> The context there is Windows Terminal Server, but I suggest you search >> HKLM >> in your registry for key names including "Access\Resiliency" and try >> deleting them. Be sure to back up the key first! >> -- >> Good Luck! >> >> Graham Mandeno [Access MVP] >> Auckland, New Zealand >> >> "JayBob" <Jay***@discussions.microsoft.com> wrote in message >> news:8B54F3E7-C67A-4ECA-BABF-2941E2F22E63@microsoft.com... >> > (banging my head against the wall) >> > >> > I have an Access 2002 MDE application that runs under MS WinXP and >> > Access >> > 2002 Runtime. It works great if opened from an Administrator account. >> > However, the following message appears if the db is opened from a user >> > account: >> > >> > "You do not have access to make the required system configuration >> > modifications. Please rerun this installation from an administrators >> > account." >> > >> > I suspected that my application was read/writing somewhere bad (like >> > HKEY_LOCAL_MACHINE), so I created a blank MDE data base... and it too >> > showed >> > the dreaded permissions message above. >> > >> > I next tried adding the user account (with full access permissions) to >> > the >> > registry under HKEY_LOCAL_MACHINE\software\microsoft and >> > HKEY_CLASSES_ROOT/CLSID. That didn't work either. >> > >> > Can Access Runtime be run from non-administrator Windows accounts? If >> > so, >> > how? >> > >> > Thanks in advance for providing any useful information! >> >> >> ouch... This was the not answer I had hoped. I have been running filemon,
regmon and procmon. 16000+ entries when Access starts up. No obviously weird stuff happening. I will go back and filter on writes only to see if there's something going on. Are there any Microsoft gurus lurking that might be able to help? Show quoteHide quote "Graham Mandeno" wrote: > Hi JayBob > > > I found one "Resiliency" entry, but it was under > > HKLM\software\microsoft\Office\10.0\word. I backed up the registry, > > deleted > > the entry and then logged out/back in as a user. No soap... Clicking the > > MDE > > startup icon (using MSACC runtime) resulted in the same permissions error. > > Hmmm... not surprising - that one would have something to do with Word, not > Access. > > > Note that the runtime application was installed as Administrator and now > > I'm > > running as a user. Could that make any difference? > > No, it shouldn't - that's the way I do all my runtime installations. > > > There's an entry under > > HKLM\software\microsoft\Office\10.0\Access called "InstallRoot" that I > > haven't noticed before. > > No, that's just the folder in which Access has been installed. Every > computer with Access installed should have that key. > > > (I'm grasping for straws here). > > I'm sorry - I've run out of straws to pass to you! :-/ > > What I'm reasonably sure of is that Access (the program - not your code) is > trying to write something to the registry and is failing. > > You might like to try RegMon or Process Monitor (I think this now includes > all the RegMon functionality and has superseded RegMon): > http://www.microsoft.com/technet/sysinternals/utilities/processmonitor.mspx > > -- > Good Luck! > > Graham Mandeno [Access MVP] > Auckland, New Zealand > > > "Graham Mandeno" wrote: > > > >> Hi JayBob > >> > >> Access Runtime certainly *can* be run from non-administrator Windows > >> accounts. > >> > >> There is a newsgroup thread on a similar subject here: > >> http://groups.google.com/group/microsoft.public.access.multiuser/browse_frm/thread/cedd70b5fa72cc20/2F8bc224c59419ad17 > >> > >> or, if that URL wraps horribly, try this one: http://tinyurl.com/y3ycqt > >> > >> The context there is Windows Terminal Server, but I suggest you search > >> HKLM > >> in your registry for key names including "Access\Resiliency" and try > >> deleting them. Be sure to back up the key first! > >> -- > >> Good Luck! > >> > >> Graham Mandeno [Access MVP] > >> Auckland, New Zealand > >> > >> "JayBob" <Jay***@discussions.microsoft.com> wrote in message > >> news:8B54F3E7-C67A-4ECA-BABF-2941E2F22E63@microsoft.com... > >> > (banging my head against the wall) > >> > > >> > I have an Access 2002 MDE application that runs under MS WinXP and > >> > Access > >> > 2002 Runtime. It works great if opened from an Administrator account. > >> > However, the following message appears if the db is opened from a user > >> > account: > >> > > >> > "You do not have access to make the required system configuration > >> > modifications. Please rerun this installation from an administrators > >> > account." > >> > > >> > I suspected that my application was read/writing somewhere bad (like > >> > HKEY_LOCAL_MACHINE), so I created a blank MDE data base... and it too > >> > showed > >> > the dreaded permissions message above. > >> > > >> > I next tried adding the user account (with full access permissions) to > >> > the > >> > registry under HKEY_LOCAL_MACHINE\software\microsoft and > >> > HKEY_CLASSES_ROOT/CLSID. That didn't work either. > >> > > >> > Can Access Runtime be run from non-administrator Windows accounts? If > >> > so, > >> > how? > >> > > >> > Thanks in advance for providing any useful information! > >> > >> > >> > > > You should be able to create a filter in procmon to show you only registry
operations which fail (exclude result is SUCCESS) and where the application is Access (include process name is MSACCESS.EXE). -- Show quoteHide quoteGood Luck! Graham Mandeno [Access MVP] Auckland, New Zealand "JayBob" <Jay***@discussions.microsoft.com> wrote in message news:64E81EA1-E5BF-4927-B7BB-F3563CE4BB35@microsoft.com... > ouch... This was the not answer I had hoped. I have been running filemon, > regmon and procmon. 16000+ entries when Access starts up. No obviously > weird > stuff happening. I will go back and filter on writes only to see if > there's > something going on. > > Are there any Microsoft gurus lurking that might be able to help? > > "Graham Mandeno" wrote: > >> Hi JayBob >> >> > I found one "Resiliency" entry, but it was under >> > HKLM\software\microsoft\Office\10.0\word. I backed up the registry, >> > deleted >> > the entry and then logged out/back in as a user. No soap... Clicking >> > the >> > MDE >> > startup icon (using MSACC runtime) resulted in the same permissions >> > error. >> >> Hmmm... not surprising - that one would have something to do with Word, >> not >> Access. >> >> > Note that the runtime application was installed as Administrator and >> > now >> > I'm >> > running as a user. Could that make any difference? >> >> No, it shouldn't - that's the way I do all my runtime installations. >> >> > There's an entry under >> > HKLM\software\microsoft\Office\10.0\Access called "InstallRoot" that I >> > haven't noticed before. >> >> No, that's just the folder in which Access has been installed. Every >> computer with Access installed should have that key. >> >> > (I'm grasping for straws here). >> >> I'm sorry - I've run out of straws to pass to you! :-/ >> >> What I'm reasonably sure of is that Access (the program - not your code) >> is >> trying to write something to the registry and is failing. >> >> You might like to try RegMon or Process Monitor (I think this now >> includes >> all the RegMon functionality and has superseded RegMon): >> http://www.microsoft.com/technet/sysinternals/utilities/processmonitor.mspx >> >> -- >> Good Luck! >> >> Graham Mandeno [Access MVP] >> Auckland, New Zealand >> >> > "Graham Mandeno" wrote: >> > >> >> Hi JayBob >> >> >> >> Access Runtime certainly *can* be run from non-administrator Windows >> >> accounts. >> >> >> >> There is a newsgroup thread on a similar subject here: >> >> http://groups.google.com/group/microsoft.public.access.multiuser/browse_frm/thread/cedd70b5fa72cc20/2F8bc224c59419ad17 >> >> >> >> or, if that URL wraps horribly, try this one: >> >> http://tinyurl.com/y3ycqt >> >> >> >> The context there is Windows Terminal Server, but I suggest you search >> >> HKLM >> >> in your registry for key names including "Access\Resiliency" and try >> >> deleting them. Be sure to back up the key first! >> >> -- >> >> Good Luck! >> >> >> >> Graham Mandeno [Access MVP] >> >> Auckland, New Zealand >> >> >> >> "JayBob" <Jay***@discussions.microsoft.com> wrote in message >> >> news:8B54F3E7-C67A-4ECA-BABF-2941E2F22E63@microsoft.com... >> >> > (banging my head against the wall) >> >> > >> >> > I have an Access 2002 MDE application that runs under MS WinXP and >> >> > Access >> >> > 2002 Runtime. It works great if opened from an Administrator >> >> > account. >> >> > However, the following message appears if the db is opened from a >> >> > user >> >> > account: >> >> > >> >> > "You do not have access to make the required system configuration >> >> > modifications. Please rerun this installation from an administrators >> >> > account." >> >> > >> >> > I suspected that my application was read/writing somewhere bad (like >> >> > HKEY_LOCAL_MACHINE), so I created a blank MDE data base... and it >> >> > too >> >> > showed >> >> > the dreaded permissions message above. >> >> > >> >> > I next tried adding the user account (with full access permissions) >> >> > to >> >> > the >> >> > registry under HKEY_LOCAL_MACHINE\software\microsoft and >> >> > HKEY_CLASSES_ROOT/CLSID. That didn't work either. >> >> > >> >> > Can Access Runtime be run from non-administrator Windows accounts? >> >> > If >> >> > so, >> >> > how? >> >> > >> >> > Thanks in advance for providing any useful information! >> >> >> >> >> >> >> >> >>
Domain user as Local admin
Show/Hide objects based on Security Groups How to secure the backend THE DATABASE ENGINE COULD NOT LOCK... Securing Records by Users Access Security Problem - User/Group Reporting fails in applicatio DbUtilities 2000 Addin "Jeff Conrad" Website & AD Authentication Access 2000 - Can Users Change Their Own Passwords? firewall config not using windows fierwall using avg |
|||||||||||||||||||||||