Use Schedule Task to run Updates, but bypass User-Level Securi
Can you provide more info on how i would indicate this info? I currently
only have it set to open access and then as you stated, the /x macro. I
pasted if this helps.
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"\\05-mis-a2\CRM\Database\DB.mdb"/x InventoryAutoUpdate
I greatly appreciate it!!! I'll continue to see if i can figure it out, but
this is my first scheduled task.
Thank you!!
--
Amanda
"Tom van Stiphout" wrote:
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!!
.
|