I have two clients now who want to have an Access 2000 & 2002 application
running on NT Server 2000 do some file updating at night when nobody is in
the office. I have used Windows scheduler to schedule the apps to start at
4:00 am, but at that time of night, nobody is logged on to the server.
Is it possible to get Access to run on a server when nobody is logged on?
Many thaks
Mike Thomas
8  3225 
"Mike Thomas" <Mi******@Yahoo .com> wrote in message
news:XV******** **************@ newssvr28.news. prodigy.com... I have two clients now who want to have an Access 2000 & 2002 application
running on NT Server 2000 do some file updating at night when nobody is in
the office. I have used Windows scheduler to schedule the apps to start
at 4:00 am, but at that time of night, nobody is logged on to the server.
Is it possible to get Access to run on a server when nobody is logged on?
Many thaks
Mike Thomas
There's no need for someone to be logged on for Scheduler to work.
Unless someone can tell us how, I'm going to say "No" because Access will try to open its
user interface when you run it. You'll need to leave someone logged on but the server
locked (Ctrl+Alt+Del, Lock Workstation or a passworded screen saver).
--
Wayne Morgan
Microsoft Access MVP
"Mike Thomas" <Mi******@Yahoo .com> wrote in message
news:XV******** **************@ newssvr28.news. prodigy.com... I have two clients now who want to have an Access 2000 & 2002 application
running on NT Server 2000 do some file updating at night when nobody is in
the office. I have used Windows scheduler to schedule the apps to start at
4:00 am, but at that time of night, nobody is logged on to the server.
Is it possible to get Access to run on a server when nobody is logged on?
Many thaks
Mike Thomas
On Thu, 20 Nov 2003 23:15:03 GMT in comp.databases. ms-access, "Mike
Thomas" <Mi******@Yahoo .com> wrote: I have two clients now who want to have an Access 2000 & 2002 application
running on NT Server 2000 do some file updating at night when nobody is in
the office. I have used Windows scheduler to schedule the apps to start at
4:00 am, but at that time of night, nobody is logged on to the server.
Is it possible to get Access to run on a server when nobody is logged on?
On Win 2000 the scheduler does prompt you for a login name/password to
run the job, it will log itself on when the time comes. Be aware it
will not log in a session on the console so an error or msgbox will be
futile (no way to press OK). Error trap everything, if an error
occurs, handle it, log it to a table, exit with noprompt/nosave. Let
the next person to log on read the error log (or hopefully, log a
success message).
There is an option to kill the job if it runs for xxx hours/minutes,
better set that to something sensible JIC, it defaults to 72 hours.
--
A)bort, R)etry, I)nfluence with large hammer.
"Wayne Morgan" <co************ *************** @hotmail.com> wrote in message
news:m9******** **********@news svr33.news.prod igy.com... Unless someone can tell us how, I'm going to say "No" because Access will
try to open its user interface when you run it. You'll need to leave someone logged on but
the server locked (Ctrl+Alt+Del, Lock Workstation or a passworded screen saver).
--
Wayne Morgan
Microsoft Access MVP
I've been using the Open event of the startup form. It checks the Len of
Command, if 0, run normally, if > 0 then run in a batch mode - it does the
needed work, then Application.Qui t. As Trevor suggested in an earlier
reply, debugging is murder. I've got many, many error traps, it still hangs
up every couple of weeks, I have to reboot the system. If it hangs, there
is abosolutely no way to tell what caused it. The scheduler kicks it off
every hour on the hour, Monday through Friday. It's been "publishing " for a
couple of years now.
"Mike Thomas" <Mi******@Yahoo .com> wrote in message
news:XV******** **************@ newssvr28.news. prodigy.com... I have two clients now who want to have an Access 2000 & 2002
application running on NT Server 2000 do some file updating at night when nobody is
in the office. I have used Windows scheduler to schedule the apps to
start at 4:00 am, but at that time of night, nobody is logged on to the server.
Is it possible to get Access to run on a server when nobody is logged
on?
Many thaks
Mike Thomas
Thanks for all the replies.
The problem here is not with the scheduler - it does its thing just fine -
in fact it runs another app, V FoxPro, just before, and another Cute FTP,
just after it is supposed to run Access. They both run correctly.
In the scheduler, Access is opened with the following command:
"c:\Program Files\Microsoft Office\Office\m saccess.exe"
"d:\Apps\Change Management.mdb" /x StartLoad
where StartLoad is a macro which calls a procedure which in turn calls the
other procs, then issues the Application.Qui t command.
When I look at the scheduler log the next day, I see the entry "Access could
not start".
When somebody is logged on, no problem, the Access app opens, a blank
looking user interface opens, it does its thing and then shuts itself down.
So I am back to the original question of whether Access can be started and
run on a server, Win 2000, when no users are logged on. It looks like the
answer is no.
Mike Thomas
"c:\Program Files\Microsoft Office\Office\m saccess.exe"
"d:\cumminsApps \ChangeManageme nt.mdb" /x StartLoad
"Trevor Best" <bouncer@localh ost> wrote in message
news:34******** *************** *********@4ax.c om... On Thu, 20 Nov 2003 23:15:03 GMT in comp.databases. ms-access, "Mike
Thomas" <Mi******@Yahoo .com> wrote:
I have two clients now who want to have an Access 2000 & 2002 application
running on NT Server 2000 do some file updating at night when nobody is
inthe office. I have used Windows scheduler to schedule the apps to start
at4:00 am, but at that time of night, nobody is logged on to the server.
Is it possible to get Access to run on a server when nobody is logged on?
On Win 2000 the scheduler does prompt you for a login name/password to
run the job, it will log itself on when the time comes. Be aware it
will not log in a session on the console so an error or msgbox will be
futile (no way to press OK). Error trap everything, if an error
occurs, handle it, log it to a table, exit with noprompt/nosave. Let
the next person to log on read the error log (or hopefully, log a
success message).
There is an option to kill the job if it runs for xxx hours/minutes,
better set that to something sensible JIC, it defaults to 72 hours.
--
A)bort, R)etry, I)nfluence with large hammer.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I had the same problem: Windows 2000 network - opened an Access 97
application using Scheduler & a .bat file. I had the .bat file write
to a log file to show when the process started & ended. If I was
logged on to the server or a workstation & ran the .bat file the
application worked OK. When the scheduler ran the .bat file it logged
the start, started the Access application & immediately logged that
the application stopped! I had other log tables inside the
application to track what was updated - nothing happended during the
automatic run. This seems to me that Access won't run when no one is
logged on, i.e., the interface needs to display to the screen before
the automatic code runs.... ???
I never could figure out what was going wrong. Had to teach the users
how to do the automatic thing manually. Luckily, I'd created a manual
interface along w/ the automatic code.
I'd be real interested to know if anyone can solve this problem.
Rgds,
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP75Mu4echKq OuFEgEQJ1/gCgwaak6N1qrarj PewSbEmHDqt94Fg AnjB7
zw8WaM9sDSg5kUp MvfKnXP4o
=yOMl
-----END PGP SIGNATURE-----
Mike Thomas wrote: Thanks for all the replies.
The problem here is not with the scheduler - it does its thing just fine -
in fact it runs another app, V FoxPro, just before, and another Cute FTP,
just after it is supposed to run Access. They both run correctly.
In the scheduler, Access is opened with the following command:
"c:\Program Files\Microsoft Office\Office\m saccess.exe"
"d:\Apps\Change Management.mdb" /x StartLoad
where StartLoad is a macro which calls a procedure which in turn calls the
other procs, then issues the Application.Qui t command.
When I look at the scheduler log the next day, I see the entry "Access could
not start".
When somebody is logged on, no problem, the Access app opens, a blank
looking user interface opens, it does its thing and then shuts itself down.
So I am back to the original question of whether Access can be started and
run on a server, Win 2000, when no users are logged on. It looks like the
answer is no.
Mike Thomas
"c:\Program Files\Microsoft Office\Office\m saccess.exe"
"d:\cumminsApps \ChangeManageme nt.mdb" /x StartLoad
"Trevor Best" <bouncer@localh ost> wrote in message
news:34******** *************** *********@4ax.c om...
On Thu, 20 Nov 2003 23:15:03 GMT in comp.databases. ms-access, "Mike
Thomas" <Mi******@Yahoo .com> wrote:
I have two clients now who want to have an Access 2000 & 2002 application
running on NT Server 2000 do some file updating at night when nobody is
in
the office. I have used Windows scheduler to schedule the apps to start
at
4:00 am, but at that time of night, nobody is logged on to the server.
Is it possible to get Access to run on a server when nobody is logged on?
On Win 2000 the scheduler does prompt you for a login name/password to
run the job, it will log itself on when the time comes. Be aware it
will not log in a session on the console so an error or msgbox will be
futile (no way to press OK). Error trap everything, if an error
occurs, handle it, log it to a table, exit with noprompt/nosave. Let
the next person to log on read the error log (or hopefully, log a
success message).
There is an option to kill the job if it runs for xxx hours/minutes,
better set that to something sensible JIC, it defaults to 72 hours.
--
A)bort, R)etry, I)nfluence with large hammer.
Does it need /nostartup to suppress the opening banner?
TC
"MGFoster" <me@privacy.com > wrote in message
news:T0******** *********@newsr ead1.news.pas.e arthlink.net... -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I had the same problem: Windows 2000 network - opened an Access 97
application using Scheduler & a .bat file. I had the .bat file write
to a log file to show when the process started & ended. If I was
logged on to the server or a workstation & ran the .bat file the
application worked OK. When the scheduler ran the .bat file it logged
the start, started the Access application & immediately logged that
the application stopped! I had other log tables inside the
application to track what was updated - nothing happended during the
automatic run. This seems to me that Access won't run when no one is
logged on, i.e., the interface needs to display to the screen before
the automatic code runs.... ???
I never could figure out what was going wrong. Had to teach the users
how to do the automatic thing manually. Luckily, I'd created a manual
interface along w/ the automatic code.
I'd be real interested to know if anyone can solve this problem.
Rgds,
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP75Mu4echKq OuFEgEQJ1/gCgwaak6N1qrarj PewSbEmHDqt94Fg AnjB7
zw8WaM9sDSg5kUp MvfKnXP4o
=yOMl
-----END PGP SIGNATURE-----
Mike Thomas wrote:
Thanks for all the replies.
The problem here is not with the scheduler - it does its thing just
fine - in fact it runs another app, V FoxPro, just before, and another Cute
FTP, just after it is supposed to run Access. They both run correctly.
In the scheduler, Access is opened with the following command:
"c:\Program Files\Microsoft Office\Office\m saccess.exe"
"d:\Apps\Change Management.mdb" /x StartLoad
where StartLoad is a macro which calls a procedure which in turn calls
the other procs, then issues the Application.Qui t command.
When I look at the scheduler log the next day, I see the entry "Access
could not start".
When somebody is logged on, no problem, the Access app opens, a blank
looking user interface opens, it does its thing and then shuts itself
down.
So I am back to the original question of whether Access can be started
and run on a server, Win 2000, when no users are logged on. It looks like
the answer is no.
Mike Thomas
"c:\Program Files\Microsoft Office\Office\m saccess.exe"
"d:\cumminsApps \ChangeManageme nt.mdb" /x StartLoad
"Trevor Best" <bouncer@localh ost> wrote in message
news:34******** *************** *********@4ax.c om...
On Thu, 20 Nov 2003 23:15:03 GMT in comp.databases. ms-access, "Mike
Thomas" <Mi******@Yahoo .com> wrote:
I have two clients now who want to have an Access 2000 & 2002
applicationrunning on NT Server 2000 do some file updating at night when nobody is
in
the office. I have used Windows scheduler to schedule the apps to
start
at
4:00 am, but at that time of night, nobody is logged on to the server.
Is it possible to get Access to run on a server when nobody is logged
on?
On Win 2000 the scheduler does prompt you for a login name/password to
run the job, it will log itself on when the time comes. Be aware it
will not log in a session on the console so an error or msgbox will be
futile (no way to press OK). Error trap everything, if an error
occurs, handle it, log it to a table, exit with noprompt/nosave. Let
the next person to log on read the error log (or hopefully, log a
success message).
There is an option to kill the job if it runs for xxx hours/minutes,
better set that to something sensible JIC, it defaults to 72 hours.
--
A)bort, R)etry, I)nfluence with large hammer.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Didn't have that in the startup command. Can't try it now 'cuz no
longer working for that client.
Anyone else can try?
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP77/vIechKqOuFEgEQL HLQCdHwRCaIgae2 6u1MPDxQ+pVWddf +wAn0Ts
CTjk45DYxe6pxxz +FTfAUZuI
=W4GU
-----END PGP SIGNATURE-----
TC wrote: Does it need /nostartup to suppress the opening banner?
TC
"MGFoster" <me@privacy.com > wrote in message
news:T0******** *********@newsr ead1.news.pas.e arthlink.net...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I had the same problem: Windows 2000 network - opened an Access 97
application using Scheduler & a .bat file. I had the .bat file write
to a log file to show when the process started & ended. If I was
logged on to the server or a workstation & ran the .bat file the
application worked OK. When the scheduler ran the .bat file it logged
the start, started the Access application & immediately logged that
the application stopped! I had other log tables inside the
application to track what was updated - nothing happended during the
automatic run. This seems to me that Access won't run when no one is
logged on, i.e., the interface needs to display to the screen before
the automatic code runs.... ???
I never could figure out what was going wrong. Had to teach the users
how to do the automatic thing manually. Luckily, I'd created a manual
interface along w/ the automatic code.
I'd be real interested to know if anyone can solve this problem.
Rgds,
MGFoster:::mg f
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP75Mu4echKq OuFEgEQJ1/gCgwaak6N1qrarj PewSbEmHDqt94Fg AnjB7
zw8WaM9sDSg5k UpMvfKnXP4o
=yOMl
-----END PGP SIGNATURE-----
Mike Thomas wrote:
Thanks for all the replies.
The problem here is not with the scheduler - it does its thing just
fine -
in fact it runs another app, V FoxPro, just before, and another Cute
FTP,
just after it is supposed to run Access. They both run correctly.
In the scheduler, Access is opened with the following command:
"c:\Progra m Files\Microsoft Office\Office\m saccess.exe"
"d:\Apps\Cha ngeManagement.m db" /x StartLoad
where StartLoad is a macro which calls a procedure which in turn calls
the
other procs, then issues the Application.Qui t command.
When I look at the scheduler log the next day, I see the entry "Access
could
not start".
When somebody is logged on, no problem, the Access app opens, a blank
looking user interface opens, it does its thing and then shuts itself
down.
So I am back to the original question of whether Access can be started
and
run on a server, Win 2000, when no users are logged on. It looks like
the
answer is no.
Mike Thomas
"c:\Progra m Files\Microsoft Office\Office\m saccess.exe"
"d:\cumminsA pps\ChangeManag ement.mdb" /x StartLoad
"Trevor Best" <bouncer@localh ost> wrote in message
news:34***** *************** ************@4a x.com...
On Thu, 20 Nov 2003 23:15:03 GMT in comp.databases. ms-access, "Mike
Thomas" <Mi******@Yahoo .com> wrote:
>I have two clients now who want to have an Access 2000 & 2002
application
running on NT Server 2000 do some file updating at night when nobody is
in
>the office. I have used Windows scheduler to schedule the apps to
start
at
>4:00 am, but at that time of night, nobody is logged on to the server.
>
>Is it possible to get Access to run on a server when nobody is logged
on?
On Win 2000 the scheduler does prompt you for a login name/password to
run the job, it will log itself on when the time comes. Be aware it
will not log in a session on the console so an error or msgbox will be
futile (no way to press OK). Error trap everything, if an error
occurs, handle it, log it to a table, exit with noprompt/nosave. Let
the next person to log on read the error log (or hopefully, log a
success message).
There is an option to kill the job if it runs for xxx hours/minutes,
better set that to something sensible JIC, it defaults to 72 hours.
--
A)bort, R)etry, I)nfluence with large hammer.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Frnak McKenney |
last post by:
Back when computer dinosaurs roamed the earth and the precursors to
today's Internet were tiny flocks of TDMs living symbiotically with
the silicon giants, tracking access to data processing resources was
much simpler: you logged in with a userID and password, and when
you were done you ended your session by logging out (or occasionally
by...
|
by: Mike Thomas |
last post by:
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...
|
by: Andre Laplume via AccessMonster.com |
last post by:
I have inherited a bunch of dbs which are are shared among a small group in
my dept. We typically use the dbs to write queries to extract data, usually
dumping it into Excel. Most dbs originated in MsAccess 97 or prior and have
been converted to 2003. On occassion user 1 will open a db. When user 2
opens the db it will not let user 2...
|
by: James Goodman |
last post by:
Ok, I had an ASP.NET application which after much trouble worked on a
server, SERVER1. I need to move this application to another server, DC2.
Both are domain controllers, both are running the same OS, SP etc.
The files are stored in C:\NET\App on SERVER1 & D:\NET\App on DC2.
I tried manually copying the files to the new server, as well...
|
by: Stuart Hemming (via DFN-CIS NetNews Service) |
last post by:
I have a WS that I call that with one method 'logs in' to a COM object
and then, with a 2nd method makes a call to the COM object and returns
some data.
Used from a web app this runs fine. This appears to be because I
always connect to the same Session on the WS Server and the
'logged-in' COM object is stored in the Session object.
If I...
| | |
by: DaveG |
last post by:
Hi all
I am planning on writing a stock and accounts program for the family
business, I understand this is likely to take close to 2 years to
accomplish. The stock is likely to run into over a thousand items and
the accounting side will be used for hopefully many years so the
entries are likely to be vast.
The delema is what is best to...
|
by: RSH |
last post by:
I have a situation where I have a page called "HiddenFrame.aspx" that
contains a public property exposing the value of a textbox called "TextBox1"
that is in a hiddenframe.
Loaded in the main frame is a page called "Page1.aspx" in which from the
code behind I need to set the value of "TextBox1" which will be persistent
following the...
|
by: mike |
last post by:
We have numerous Access 97 apps that we run on our Terminal Server,
but two apps in particular is giving us a problem. The problem we are
running into is when you select a drop down menu, it errors out saying
the SQL server cannot be found. This is through the terminal session
and when logged on the server locally.
If I run the apps on my...
|
by: Paul Brady |
last post by:
I have two users, Andrew and Nancy, who each have their own computer
and can connect to a common database called "employees.mdb" which
resides on a network server. On that same network server, there is a
folder containing jpegs of the employee pictures. When either person
brings up an employee's file, the computer goes into the network and...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
