View Single Post
  #2  
Old May 18th, 2010, 03:34 PM posted to microsoft.public.access.tablesdbdesign
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Use Schedule Task to run Updates, but bypass User-Level Security

On Mon, 17 May 2010 09:52:01 -0700, amanda_jb
wrote:

Check out the command line options for msaccess.exe. You can add your
username and password in addition to the (I presume) /x option to run
the macro.

-Tom.
Microsoft Access MVP


I am trying to run a scheduled task to run a macro with updates, but have to
enter my Password as soon as Access opens, is there a way around this so it
can be ran while i'm away? The only place I see to enter in the actual Task
is for the Windows Login itself.

Help please!!!

Thank you!!