Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Setup / Configuration / October 2003

Tip: Looking for answers? Try searching our database.

Access Will Not Start via Scheduler

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike Thomas - 23 Oct 2003 21:07 GMT
We have an Access 2000 app which is supposed to run every morning via the
Windows scheduler using the following command:

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

Where Start Load is a macro which simply calls a procedure, which in turn
call several other procedures, then finishes with the "Quit" command.

The problem is that it appears that when the system administrator is not
logged on Access is either not starting at all, or it is starting and
immediately hanging up - it's first task is to write a text file saying that
it has started, and this text file is not showing up.

These are the specifics:

The app is running on NT 2000 running Citrix.

When the system administrator is logged onto the server, the scheduler opens
Access, it runs, and everything is fine, so we think the above command is OK
and the program itself is executing without errors.

When he runs the above command from the Run window, everything works fine.

When he is not logged on, we have the problem described above and hours
later the scheduler thinks Access is still running.

He is at a loss and so am I. Does anyone have any idea why Access is either
not opening, or is opening and immediately stopping when the system
administrator is not logged in.

Many thanks

Mike Thomas
gandalf - 24 Oct 2003 08:59 GMT
Have you filled in the user?
Checked the security tab?

>-----Original Message-----
>We have an Access 2000 app which is supposed to run every morning via the
[quoted text clipped - 33 lines]
>
>.
Ray Delevaux - 29 Oct 2003 02:13 GMT
Dear gandalf,

I happen to have the same problem as Mike, and I would be very pleased to have found someone who has a solution for this problem.  However, your answers are in fact questions, and may do nothing to help myself and Mike sort out this problem.  

Fill in the user?  What? Where? How?  Really, I think you need to be a bit more explicit here.  

Checked the security tab?  Which security tab? Where? Check for what?

I do think I have an idea what you mean, so let me answer back like this:
Yes.
Yes.

It still doesn't work.  What now gandalf?

Anybody else out there who is not only knowledgeable but a good communicator too?

BTW this works fine in windows XP prof., I have the problem on a win 2k server.

Regards,

Ray Delevaux

> Have you filled in the user?
> Checked the security tab?
[quoted text clipped - 48 lines]
> >
> >.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.