Re: Use task scheduler to start up an MDB form?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

thanks for your reply. the answer is that yes, i am specifying the full
path name of the MDB.

i've tried two approaches.
1. created a .BAT file, that startus up access with the target database
(and full path name), and uses the /x macro command line swtich to call the
macro i mentioned. double clicking on the batch file starts things up just
fine. but having either task scheduler call the batch file does create an
MSACCESS.EXE task, but it seems to go nowhere and do nothing.

2. so i tried having each task scheduler call access directly, by copying
and pasting the contents of the batch file into the scheduler. this has the
same effect.

so, any more help would be appreciated!

fred



"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:04926FC4-6FCE-49DA-B244-89BDD7C365D5@xxxxxxxxxxxxxxxx
> are you specifiying the name of the mdb with the full path to it?
>
> "fred" wrote:
>
>> hi,
>>
>> i'm not sure which newsgroup to use, so feel free to point me elsewhere.
>> (I've tried one other newsgroup.)
>>
>> i have an MDB that produces many reports, automatically (via the startup
>> form's on open script). works great.
>>
>> now, i want to automate this, so that it happens once every evening. i
>> created a macro that can be called via an Access startup command, and
>> double clicking on a .bat file that uses this, it works great too.
>>
>> so, now i've tried both XP's task scheduler, and also sql server agent.
>> but neither seems to work. they start up Access (i see an MSACCESS.EXE
>> task in the Processes tab), but the task does not seem to do anything. i
>> have to kill the Access task.
>>
>> anyone have any hints on how to do automatically trigger Access to start
>> up?
>>
>> thanks!
>>
>> fred
>>


.

Relevant Pages

  • Re: Task Scheduler job Hangs (rundll32 printui.dll,PrintUIEntry)
    ... I modified my batch file to include your recommendation. ... The bat file ... related to a batch job hanging when initiated via Task Scheduler. ... I take the same batch job and initiate it with the ...
    (microsoft.public.windows.server.general)
  • Re: Scheduled tasks dont end
    ... corrected bat file in the morning. ... you ran an invalid batch file. ... the following batch file under the Task Scheduler: ... I suspect that Winzip ...
    (microsoft.public.windowsxp.general)
  • Re: pb with a Scheduled Task
    ... What does your batch file look like? ... What does the Task Scheduler log file report? ... i installed a new server in my domain with 2008 STD edition in replacement of a 2003R2 to host a database ... on the old server i was running a Scheduled Task every night who lauch a bat file ...
    (microsoft.public.windows.server.general)
  • Re: How to sync time w/o proper permisisons
    ... Use the Task Scheduler to run the batch file. ... set it to run the Bat file with a set of credentials. ... So through GPMC I restricted their access to edit the ...
    (microsoft.public.windows.server.sbs)
  • Re: How to sync time w/o proper permisisons
    ... Phillip Windell ... >> Event Source: W32Time ... >>> I don't believe the Task Scheduler will solve my problem. ... >>> batch file to my local drive to see if it would run from there. ...
    (microsoft.public.windows.server.sbs)