I'm trying to start a session in Access2003 using VBScript. I have no
knowledge of VBScript at all. To make it short I trying to use VBScript to
set the security level to low to stop an blocking unsafe procedures error
message. I have found the following code at a web sight

Set o = CreateObject("Access.Application")
o.AutomationSecurity = 1 ' set macro security LOW.
o.OpenCurrentDatabase "full path to your database"
o.UserControl = True
Set o = Nothing

I've been told if I create a file with this in it and use that file as a
short to start Access it will work. Well, the basic question is how do I
create the file? Do I need certain software to create a VBScript file? Can
I do it in Access or maybe Visual Basic? I have both.

Thanks for the help

Re: First Time with VBScript by McKirahan

McKirahan
Tue Mar 15 17:51:38 CST 2005

"Eddy" <tsrllc@yahoo.com> wrote in message
news:#xE4PbbKFHA.904@tk2msftngp13.phx.gbl...
> I'm trying to start a session in Access2003 using VBScript. I have no
> knowledge of VBScript at all. To make it short I trying to use VBScript to
> set the security level to low to stop an blocking unsafe procedures error
> message. I have found the following code at a web sight
>
> Set o = CreateObject("Access.Application")
> o.AutomationSecurity = 1 ' set macro security LOW.
> o.OpenCurrentDatabase "full path to your database"
> o.UserControl = True
> Set o = Nothing
>
> I've been told if I create a file with this in it and use that file as a
> short to start Access it will work. Well, the basic question is how do I
> create the file? Do I need certain software to create a VBScript file?
Can
> I do it in Access or maybe Visual Basic? I have both.
>
> Thanks for the help

If I understand your question:

use Notepad and save it with a .vbs extension.