[AccessD] Scheduled Access task - URGENT

Kath
Unless it's changed in A2K the command line in A97 would end ".... /x
Autorun" not /cmd.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Kath Pelletti
> Sent: 13 July 2004 02:17
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Scheduled Access task - URGENT
> 
> 
> I need to set up an overnight task in Windows Scheduler, (Win 
> XP Pro) to open an Access database. This is what I have put 
> in the 'Run' line, but I don't get even a flicker from it.
> 
> "C:\Program Files\Microsoft Office 2000\Office\MSACCESS.EXE" 
> "E:\Sds\Clients\DDTolhurst\IressPricesDatabase\TestBatch.mdb" 
> /cmd AutoRun
> 
> The TestBatch.mdb has a startup form, with this 'On Open' event:
> 
> --------------------------------------------------------------
> ------------------
> 
> Private Sub Form_Open(Cancel As Integer)
> If Command$ = "AutoRun" Then
>        MsgBox ("In")        
>        ' Call procedure(s) to perform the necessary tasks.
>         'Call BasProcessItems
> End If
> 
> End Sub
> 
> --------------------------------------------------------------
> ------------------
> 
> 
> This one is urgent - any help??
> 
> 
> Kath Pelletti
> Software Design & Solutions Pty Ltd.
> Ph: 9505-6714
> Fax: 9505-6430
> KP at SDSOnline.net
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 
>