John Skolits
JohnSkolits at corporatedatadesign.com
Fri Dec 10 07:57:44 CST 2004
The IT person had a question. Maybe someone could answer it. John, Can you ask if there is a specific group policy setting that would allow this? I'm not sure, I may have prevented the user from doing something I shouldn't have. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Spam Sent: Thursday, December 09, 2004 9:23 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Running Access 2002 runtime on an Windows XP machine Thanks Charlotte and William. Charlotte: I think if the MDB was read only, then it wouldn't work when logged into the OS as administrator: William: I'll pass these ideas onto my customer. Hopefully one of them will work. Thanks a million! John -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman Sent: Thursday, December 09, 2004 9:09 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Running Access 2002 runtime on an Windows XP machine John ..I run several client systems with Access runtimes without giving anyone admin rights ..have you looked at your group policies? ...if others are making changes there it can have unintended consequences like you describe. ..for a couple of legacy DOS apps that refused to run without admin rights no matter what I did I've resorted to using shortcuts with the "run as" command ...see: http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en- us/windows_security_runas_shortcut.mspx ..this lets a user run a specific app with the admin rights you specify and I've had little problem with it ...but of course ANY time you've got someone logged on with admin rights there is a potential for severe problems ...so I limit it to cases where nothing else gets the job done, not just as an easy out. ..I did have some problems initially with the Win2003/XP SPS2 combo and Access runtimes after the upgrade to Win2003 ...the only answer I found was to repackage the runtime deployment in that environment ...I have no explanation for it and its more than possible there's another solution I'm not aware of. ..hth :) William Hindman ----- Original Message ----- From: "Spam" <JohnSkolits at corproatedatadesign.com> To: <accessd at databaseadvisors.com> Sent: Thursday, December 09, 2004 3:18 PM Subject: [AccessD] Running Access 2002 runtime on an Windows XP machine Anyone have a problem running a 'runtime' version of Access on a machine in which the user is not the "OS "administrator? I have tried "super user" but the user can't delete any records. Says no permissions. This is not the user logging into Access that seems to be the issue. It seems to be the user logging onto the PCs operating system when they start the PC. A user with operating system administrative rights has no problem. Also, if I log on to the OS as the user with limited rights and run the app as an administrator (can do that by right-clicking on the apps, icon and selecting :"Run As") it the app runs with no problems.. Any ideas? Any way of launching an app and specifying the administrator as the user. Maybe a command line argument? Thanks, John -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com