If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Use Schedule Task to run Updates, but bypass User-Level Security
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 |
#2
|
|||
|
|||
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!! |
#3
|
|||
|
|||
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!! . |
#4
|
|||
|
|||
Use Schedule Task to run Updates, but bypass User-Level Securi
On Tue, 18 May 2010 09:42:03 -0700, amanda_jb
wrote: 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!! Is this a database password, or User Level Security (workgroup security)? They're different! If you have a .mdw file with user and group names and user passwords you need to reference the workgroup: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "\\05-mis-a2\CRM\Database\DB.mdb"/x InventoryAutoUpdate /wrkgrp "\\05-mis-a2\CRM\database\SomeFile.mdw" /user JoeUser /pwd MyPassword If it's a password protected database I'm guessing the /pwd command line switch will work but the Help is ambiguous and I haven't tried it! -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Use Schedule Task to run Updates, but bypass User-Level Securi
On Tue, 18 May 2010 09:42:03 -0700, amanda_jb
wrote: Odd. I replied but my answer promptly got deleted... not sure why. I'll obfuscate the word that might be getting it trashed... 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!! Is this a database pass-word, or User Level Security (workgroup security)? They're different! If you have a .mdw file with user and group names and user pass-words you need to reference the workgroup: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "\\05-mis-a2\CRM\Database\DB.mdb"/x InventoryAutoUpdate /wrkgrp "\\05-mis-a2\CRM\database\SomeFile.mdw" /user JoeUser /pwd MyPasswd If it's a pass-word protected database I'm guessing the /pwd command line switch will work but the Help is ambiguous and I haven't tried it! -- John W. Vinson [MVP] -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|