I have automated my database to run during non peak times when no one is
around and so that the Current data will be available when they come in the
next morning.

The problem I'm having is that when the database opens at the scheduled time
(Windows scheduler) it launches creates the links and then hangs there until
I come in in the morning and log on to my computer.

Windows Scheduler allows me to store my user ID and password, so this should
not be an issue.

Once I log in the database continues without any input on my behalf.
This whole delay is causing problem as the data is not available to the end
users at the needed times.

Does anyone have a thought on this or run into a similar experience?

On Thu, 25 Feb 2010 08:47:01 -0800, Mike <(E-Mail Removed)>
wrote:

>I have automated my database to run during non peak times when no one is
>around and so that the Current data will be available when they come in the
>next morning.
>
>The problem I'm having is that when the database opens at the scheduled time
>(Windows scheduler) it launches creates the links and then hangs there until
>I come in in the morning and log on to my computer.
>
>Windows Scheduler allows me to store my user ID and password, so this should
>not be an issue.
>
>Once I log in the database continues without any input on my behalf.
>This whole delay is causing problem as the data is not available to the end
>users at the needed times.
>
>Does anyone have a thought on this or run into a similar experience?

You'll have to explain what you mean by "to run". Databases don't "run"; code
or queries in databases do.

What exactly happens when you open the database with Windows Scheduler? Do you
have a Startup Macro or form, or do you use the /x Macroname command line
switch to execute a specific macro (which might run some code or queries)?
More info please!
--

John W. Vinson [MVP]

Sorry, I use an autoexec macro to open a form. The form creates the links and
then executes a make table query (SQL statement) based upon the links. From
the out to text file routine I have in the code, I can see the links are
created and then the process hangs until I log on in the morning. No errors
or waiting for user input, once I log in the code continues until the process
is finished.

"John W. Vinson" wrote:

> On Thu, 25 Feb 2010 08:47:01 -0800, Mike <(E-Mail Removed)>
> wrote:
>
> >I have automated my database to run during non peak times when no one is
> >around and so that the Current data will be available when they come in the
> >next morning.
> >
> >The problem I'm having is that when the database opens at the scheduled time
> >(Windows scheduler) it launches creates the links and then hangs there until
> >I come in in the morning and log on to my computer.
> >
> >Windows Scheduler allows me to store my user ID and password, so this should
> >not be an issue.
> >
> >Once I log in the database continues without any input on my behalf.
> >This whole delay is causing problem as the data is not available to the end
> >users at the needed times.
> >
> >Does anyone have a thought on this or run into a similar experience?
>
> You'll have to explain what you mean by "to run". Databases don't "run"; code
> or queries in databases do.
>
> What exactly happens when you open the database with Windows Scheduler? Do you
> have a Startup Macro or form, or do you use the /x Macroname command line
> switch to execute a specific macro (which might run some code or queries)?
> More info please!
> --
>
> John W. Vinson [MVP]
> .
>