Startup script Where to Put it

  • Thread starter Thread starter Eddy
  • Start date Start date
E

Eddy

I found this code at some web site for setting security to low when
starting access. My problem being new to programming is where do I put it.
If I put it or behind the Splash screen, teh database is already open so the
first line opens a second copy of Access.

Thanks

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
AutomationSecurity = 1 ' set macro security LOW.
UserControl = True
 
Eddy

Looks lile this code is designed to be a stand-alone script file that loads
your database after setting the security level to low. You need to create a
file on the disk with a ".scr" extension. You will need to change the
string "full path to your database" to the (ahem) full path to the database
you want to run. The idea is that the user would double click this file or
a shortcut that pointed to this file to start your app. Think of this as a
new fangled high tech BAT file.

BTW I believe you will need to delete the two lines after Set o = Nothing.
I do not believe they do anything useful.

Ron W
 
Back
Top