Re: Start database ved AT.exe



* jj:
Hi Ng

When I use the AT.exe to schedule a job and I write:
at.exe 22:54 /every:24 "c:\test.bat" this job works just perfect.

In the bat file I have wrote:

copy c:\TestDB.mdb c:\testfolder (I copy the Test database from C to C:\testfolder)

Then when I Change the test.bat file to:

"C:\Programmer\Microsoft Office\OFFICE11\msaccess.exe" "C:\TestDB.mdb" (I activate the test database) - This doesn't work!!!!

It works when I double click the bat-file

TIA
jj



This is a complete guess, but maybe worth a try. Put the TestDB.mdb in a directory. (c:\temp\TestDB.mdb). Maybe the Scheduler has trouble writing to C:\. That would explain why it works for a logged in user.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
.



Relevant Pages

  • Re: Start database ved AT.exe
    ... When I use the AT.exe to schedule a job and I write: ... In the bat file I have wrote: ... (I activate the test database) ... tech at promail dot com ...
    (comp.databases.ms-access)
  • Start database ved AT.exe
    ... When I use the AT.exe to schedule a job and I write: ... In the bat file I have wrote: ... activate the test database) - This doesn't work!!!! ... It works when I double click the bat-file ...
    (comp.databases.ms-access)
  • Re: Unhandled Exception Handler
    ... I have a BAT file that runs the application thussly. ... runs fine manually, but when it runs on the schedule, each invocation ... think may help is to add an Unhandled Exception handler to the app so ... The application is a Windows Application that has a Sub Main as the ...
    (microsoft.public.dotnet.languages.vb)
  • Unhandled Exception Handler
    ... one customer site, it behaves strangely. ... I have a BAT file that runs the application thussly. ... runs fine manually, but when it runs on the schedule, each invocation ... The application is a Windows Application that has a Sub Main as the ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Schedule a task
    ... If I schedule single commad all work fine. ... > I have created a user, I have added to the "Backup Operators" group. ... > task (a bat file) run correctly. ...
    (microsoft.public.windows.server.security)