[AccessD] Scheduled Access task - URGENT

Thanks very much Stuart - it's always great to have a version that someone has working!

You were right about the run permissions - I had checked them but as I do not have a password for user Win I didn't enter one - I had no idea that that was required (which still strikes me as odd)

Brilliant - thanks all. 

Kath

  ----- Original Message ----- 
  From: Stuart McLachlan 
  To: access Developers discussion and problem solving 
  Sent: Tuesday, July 13, 2004 11:12 PM
  Subject: Re: [AccessD] Scheduled Access task - URGENT


  On 13 Jul 2004 at 22:27, Kath Pelletti wrote:

  > 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? 
  > 

  With the attached test.mdb  (not attached to list reply) in C:\ I've just run a 
  scheduled task with the comand line
  "C:\Program Files\Microsoft Office\Office\MsAccess.exe" "c:\test.mdb" /cmd Test 
  Argument

  It works fine (opens the mdb and displays two message boxes, once from a 
  function called in the Autoexec macro and a second one called from the startup 
  forms on_open.

  Having just set up the  task, the thought struck me that you may not have set 
  the run permissions for the task properly. You need to set the "Run as" and  
  password for the task.

   



  Attachments:
    C:\test.mdb 
  -- 
  Lexacorp Ltd
  http://www.lexacorp.com.pg
  Information Technology Consultancy, Software Development,System Support.



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