Use Schedule Task to run Updates, but bypass User-Level Security
in [Tables]
|
Prev: Test
Next: How to change existing table record value by VBA and How to add new record in existing table by VBA
From: amanda_jb on 17 May 2010 12:52 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!! -- Amanda
From: Tom van Stiphout on 18 May 2010 10:34
On Mon, 17 May 2010 09:52:01 -0700, amanda_jb <amandajb(a)discussions.microsoft.com> 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!! |