By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,448 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Retry - Start Access via Scheduler w/ Nobody Logged onto Server

P: n/a
I want to start this thread again - on my first attempt I was a little
ambiguous and was not able to get the answer I need.

I am trying to start Access 2000 on Windows NT 2000 Server by using the
scheduler with the command line:

"c:\Program Files\Microsoft Office\Office\msaccess.exe"
"d:\Apps\ChangeManagement.mdb" /x StartLoad

This works when I run it from the "run" box, or via the scheduler when I am
logged on to the server. Access opens, the macro calls a procedure which
does what it needs to do and then closes Access down.

The scheduler, apparently, cannot start Access at 5:00 am when nobody is
logged on. The scheduler's log will show "Access could not start" the next
morning. The scheduler does successfully run a V FoxPro app before and a
Cute FPT macro after trying to run Access, so I know the scheduler is OK.

What I need to know is whether Access can be started on a server via the
scheduler when nobody is logged on, and if so, how. I don't want to give up
on the plan if it is doable.

Many thanks,
Mike Thomas

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Fri, 21 Nov 2003 17:30:41 GMT, "Mike Thomas" <Mi******@Yahoo.com>
wrote:
I want to start this thread again - on my first attempt I was a little
ambiguous and was not able to get the answer I need.

I am trying to start Access 2000 on Windows NT 2000 Server by using the
scheduler with the command line:

"c:\Program Files\Microsoft Office\Office\msaccess.exe"
"d:\Apps\ChangeManagement.mdb" /x StartLoad

This works when I run it from the "run" box, or via the scheduler when I am
logged on to the server. Access opens, the macro calls a procedure which
does what it needs to do and then closes Access down.

The scheduler, apparently, cannot start Access at 5:00 am when nobody is
logged on. The scheduler's log will show "Access could not start" the next
morning. The scheduler does successfully run a V FoxPro app before and a
Cute FPT macro after trying to run Access, so I know the scheduler is OK.

What I need to know is whether Access can be started on a server via the
scheduler when nobody is logged on, and if so, how. I don't want to give up
on the plan if it is doable.

Many thanks,
Mike Thomas


AFAIK the answer is No. See

http://support.microsoft.com/default...b;EN-US;257757

and
http://support.microsoft.com/default...66&Product=acc

The solution I would use in this situation is to write the code in
Visual Basic and to implement a true service with the aid of the "NT
Service Toolkit" from Desaware (www.desaware.com).

HTH
Matthias Kläy
--
www.kcc.ch
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.