[AccessD] Running Access 2002 runtime on an Windows XP machine

Spam JohnSkolits at corporatedatadesign.com
Thu Dec 9 20:22:45 CST 2004


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




More information about the AccessD mailing list