[AccessD] Scheduled Access task - URGENT

Kath Pelletti KP at sdsonline.net
Tue Jul 13 07:27:12 CDT 2004


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


More information about the AccessD mailing list