|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
using the opencurrentdatabase in scriptHi
I'm using a vbs to open an access file. Problem is that if the user do not have admin rights in windows, this method do not work. Any one know why, or even how to solve this without giving the user admin rights? (Reason for runing the script is to set the automationsecurity to low before opening the file. I do not want the automationsecurity to be low on a permanent setting, and all users should not be granted admin rights) Thank you! Frode wrote:
> I'm using a vbs to open an access file. Problem is that if the user do not For security reasons your windows admin has locked down the users' accounts> have admin rights in windows, this method do not work. Any one know why, so that scripts won't run. This cuts down on malicious viruses. > (Reason for runing the script is to set the automationsecurity to low before Then none of the non-admin users with Access 2003 will be opening your> opening the file. I do not want the automationsecurity to be low on a > permanent setting, and all users should not be granted admin rights) database unless you sign it with a digital certificate and they *trust* that certificate. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200610/1 Granny Spitz wrote:
> Then none of the non-admin users with Access 2003 will be opening your At least not without the security warnings if their computers are set at> database unless you sign it with a digital certificate and they *trust* that > certificate. medium, and not at all if they're set at high. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200610/1 "Granny Spitz via AccessMonster.com" wrote: No, that is not the case. The script is running just fine. Using error > Frode wrote: > > I'm using a vbs to open an access file. Problem is that if the user do not > > have admin rights in windows, this method do not work. Any one know why, > > For security reasons your windows admin has locked down the users' accounts > so that scripts won't run. This cuts down on malicious viruses. > handling the error description is about: "File not found or open exclusive by another user", neither is true. The script is creating the access application object, but errors when using the opencurrentdb.... I gave the account admin rights to its own windows session, and volla everthing works just nice and dandy. Show quoteHide quote > > (Reason for runing the script is to set the automationsecurity to low before > > opening the file. I do not want the automationsecurity to be low on a > > permanent setting, and all users should not be granted admin rights) > > Then none of the non-admin users with Access 2003 will be opening your > database unless you sign it with a digital certificate and they *trust* that > certificate. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200610/1 > > Frode wrote:
>> > I'm using a vbs to open an access file. Problem is that if the user do not Like I said hon, the windows admin locked down users' accounts. If you'd>> > have admin rights in windows, this method do not work. Any one know why, >> >> For security reasons your windows admin has locked down the users' accounts >> so that scripts won't run. This cuts down on malicious viruses. >> > > No, that is not the case. The script is running just fine. Using error > handling the error description is about: "File not found or open exclusive by > another user", neither is true. The script is creating the access application > object, but errors when using the opencurrentdb.... I gave the account admin > rights to its own windows session, and volla everthing works just nice and > dandy. given me the exact error message instead of "this method doesn't work" for non-admin users, I'd have been able to tell you with more precision what's wrong when running the script. I had to assume the script was blocked because you didn't mention error messages. So now the users have admin rights? Wasn't one of your criteria in your first post that users *shouldn't* be granted admin rights? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200610/1 Hi
Yes, the test account with admin rights worked. IT will not give all (20) users admin rights so case not solved (he, he). But strange thing is after revoking the admin rights on the test account, it still worked! So must be a reg key setting og file setting that is generated to enable the opencurrentdatabase... I'm lost. But thank you for the involvment. I was hoping someone else have had same problem, and solved it. Thank you. Frode wrote:
> But thank you for the involvment. I was You're welcome, Frode. Many people solve it by digitally signing the> hoping someone else have had same problem, and solved it. database (Microsoft's recommendation), or setting macro security to low (Access developers' recommendation). The rest use the automation security script, as long as they aren't using User level security and scripts aren't blocked/restricted on the computer. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200610/1 
Other interesting topics
|
|||||||||||||||||||||||
