[AccessD] Scheduled Access task - URGENT

Thanks Steve - that was it. Glad to have this one in the archives.

Kath
  ----- Original Message ----- 
  From: Steve Conklin (Developer at UltraDNT) 
  To: 'Access Developers discussion and problem solving' 
  Sent: Wednesday, July 14, 2004 2:32 AM
  Subject: RE: [AccessD] Scheduled Access task - URGENT


  Does the Windows user id have a password? 
  In my experience, WinXP won't run a Scheduled Task for a user id that
  does not have one.

  hth
  Steve


  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
  Sent: Tuesday, July 13, 2004 8:27 AM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Scheduled Access task - URGENT


  Hi Gustav / Stuart / Andy - thanks for suggestions - 

  I can't get it to work with or without the quotes around the Autorun
  parameter.

  This is Win XP Pro - so maybe there is a difference between Win 2K and
  XP Pro here. The mdb I am using is completely empty - vanilla - I
  started with an empty mdb and just added one startup form when I
  couldn't get the more complex one to work. 

  My syntax works as a shortcut, but simply does not run as a scheduled
  task.

  To confirm that it is a Win issue, could you send me your Win2K line
  syntax with an mdb which it opens? 

  Much appreciated

  Kath
    ----- Original Message ----- 
    From: Gustav Brock 
    To: Access Developers discussion and problem solving 
    Sent: Tuesday, July 13, 2004 7:25 PM
    Subject: Re: [AccessD] Scheduled Access task - URGENT


    Hi Stuart

    OK, I didn't test it myself, neither have I never had the need.

    I guess that leaves Kath with a problem somewhere else ...

    /gustav


    >> I think you need to modify
    >> 
    >> "C:\Program Files\Microsoft Office 2000\Office\MSACCESS.EXE"
    >> "E:\Sds\Clients\DDTolhurst\IressPricesDatabase\TestBatch.mdb"
    >> /cmd AutoRun
    >> 
    >> to
    >> 
    >> "C:\Program Files\Microsoft Office 2000\Office\MSACCESS.EXE"
    >> "E:\Sds\Clients\DDTolhurst\IressPricesDatabase\TestBatch.mdb"
    >> /cmd "AutoRun"
    >> 

    > It works fine for me without quotes around the argument(s)
    > Trying to find Kath's problem, this works as expected and a message
  box 
    > displays the two words when called from a form's on_open

    > "C:\Program Files\Microsoft Office\Office\MsAccess.exe"
  "c:\test.mdb" /cmb Test 
    > Argument

    > It works fine whether in a shortcut or a batch file (Win2K, A2K)

    -- 
    _______________________________________________
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
  -- 
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

  -- 
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com