Security Startup Dialog

[teresaeiben@gmail.com]

I'm changing from excel to using an html page to open tons of db at
work.
After reading tons of posting about this subject, for simplicity sake
I need the code to run on startup, to change the security settings to
low, so users don't get the message "Some files can harm your
computer". any way I founds this: which I put on the load of the
switchboard; using 97 still. I do NOT get this error when using excel
to open db, just html. Since there are tons of users and db, having
users change their security setting to low in not an option.

dim o
set o=createobject ("Access.Applic ation")
o.automationsec urity=1 ' set macro security LOW.
o.opencurrentda tabase "full path to your database"
o.visible=true
o.usercontrol=t rue
set o=nothing

when it reaches
set o = createobject ("access.applic ation") I get a run-time 438
object doesn't support this property or method.
Any idea how to get this to run, or alternative code. help would
greatly be appreciated

[Tom van Stiphout]

Re: Security Startup Dialog

On Fri, 29 Feb 2008 04:43:23 -0800 (PST), teresaeiben@gma il.com wrote:

HTML page? Do you mean a file with a .htm extension, the extension
typically used for static web pages?
If so, there are MUCH simpler solutions.

If you like to write in Javascript and stay with web-like technologies
you could create a HTA application. CreateObject would not work, but
something like this would:
var objXlApp = new ActiveXObject(" Excel.Applicati on");
var objXlWb = objXlApp.Workbo oks.Open(strFil e);
var objXlWs = objXlWb.Sheets( "Sheet1")

If you like to write in vbScript, use the Windows scripting host
(wscript.exe). I took your code and saved it in Notepad as test.vbs,
then ran it from the Run prompt as wscript.exe test.vbs
and it worked. At least CreateObject did. You're on your own with
setting macro security. I would be surprised if it was as simple as
o.automationsec urity=1
but I can easily be persuaded by working code :-)

-Tom.

>I'm changing from excel to using an html page to open tons of db at
>work.
>After reading tons of posting about this subject, for simplicity sake
>I need the code to run on startup, to change the security settings to
>low, so users don't get the message "Some files can harm your
>computer". any way I founds this: which I put on the load of the
>switchboard; using 97 still. I do NOT get this error when using excel
>to open db, just html. Since there are tons of users and db, having
>users change their security setting to low in not an option.
>
>dim o
>set o=createobject ("Access.Applic ation")
>o.automationse curity=1 ' set macro security LOW.
>o.opencurrentd atabase "full path to your database"
>o.visible=tr ue
>o.usercontrol= true
>set o=nothing
>
>when it reaches
>set o = createobject ("access.applic ation") I get a run-time 438
>object doesn't support this property or method.
>Any idea how to get this to run, or alternative code. help would
>greatly be appreciated

[teresaeiben@gmail.com]

Re: Security Startup Dialog

On Feb 29, 9:49 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:

On Fri, 29 Feb 2008 04:43:23 -0800 (PST), teresaei...@gma il.com wrote:
>
HTML page?  Do you mean a file with a .htm extension, the extension
typically used for static web pages?
If so, there are MUCH simpler solutions.
>
If you like to write in Javascript and stay with web-like technologies
you could create a HTA application. CreateObject would not work, but
something like this would:
    var objXlApp = new ActiveXObject(" Excel.Applicati on");
    var objXlWb = objXlApp.Workbo oks.Open(strFil e);
    var objXlWs = objXlWb.Sheets( "Sheet1")
>
If you like to write in vbScript, use the Windows scripting host
(wscript.exe). I took your code and saved it in Notepad as test.vbs,
then ran it from the Run prompt as wscript.exe test.vbs
and it worked. At least CreateObject did. You're on your own with
setting macro security. I would be surprised if it was as simple as
o.automationsec urity=1
but I can easily be persuaded by working code :-)
>
-Tom.
>
>
>

I'm changing from excel to using an html page to open tons of db at
work.
After reading tons of posting about this subject, for simplicity sake
I need the code to run on startup, to change the security settings to
low, so users don't get the message "Some files can harm your
computer". any way I founds this: which I put on the load of the
switchboard; using 97 still. I do NOT get this error when using excel
to open db, just html. Since there are tons of users and db, having
users change their security setting to low in not an option.

>

dim o
set o=createobject ("Access.Applic ation")
o.automationsec urity=1 ' set macro security LOW.
o.opencurrentda tabase "full path to your database"
o.visible=true
o.usercontrol=t rue
set o=nothing

>

when it reaches
set o = createobject ("access.applic ation") I get a run-time 438
object doesn't support this property or method.
Any idea how to get this to run, or alternative code. help would
greatly be appreciated- Hide quoted text -

>
- Show quoted text -

Yes I mean a html or htm page. I had never heard of a hta before. I
can't code in Javascript. I tried the vbScript thing but it's blocked,
so I have to accomplish this using htm. Any other ideas