Security Startup Dialog

[teresaeiben]

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.Application")
o.automationsecurity=1 ' set macro security LOW.
o.opencurrentdatabase "full path to your database"
o.visible=true
o.usercontrol=true
set o=nothing

when it reaches
set o = createobject ("access.application") 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]

On Fri, 29 Feb 2008 04:43:23 -0800 (PST), te*********@gmail.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.Application");
var objXlWb = objXlApp.Workbooks.Open(strFile);
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.automationsecurity=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.Application")
o.automationsecurity=1 ' set macro security LOW.
o.opencurrentdatabase "full path to your database"
o.visible=true
o.usercontrol=true
set o=nothing

when it reaches
set o = createobject ("access.application") 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]

On Feb 29, 9:49*am, Tom van Stiphout <[e-mail]:

On Fri, 29 Feb 2008 04:43:23 -0800 (PST), [e-mail] 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.Application");
* * var objXlWb = objXlApp.Workbooks.Open(strFile);
* * 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.automationsecurity=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.Application")
o.automationsecurity=1 ' set macro security LOW.
o.opencurrentdatabase "full path to your database"
o.visible=true
o.usercontrol=true
set o=nothing

when it reaches
set o = createobject ("access.application") 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