View Single Post
  #5  
Old May 18th, 2010, 11:16 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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]