Prev: How to change existing table record value by VBA and How to add new
Next: Filter Form based on OnClick from Text Box of another form
From: amanda_jb on 18 May 2010 12:42
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
> <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!!
> .
>
From: John W. Vinson on 18 May 2010 18:00
On Tue, 18 May 2010 09:42:03 -0700, amanda_jb
<amandajb(a)discussions.microsoft.com> 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]
From: John W. Vinson on 18 May 2010 18:16
On Tue, 18 May 2010 09:42:03 -0700, amanda_jb
<amandajb(a)discussions.microsoft.com> 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]
 | 
Pages: 1
Prev: How to change existing table record value by VBA and How to add new
Next: Filter Form based on OnClick from Text Box of another form