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

[Randy Harris]

* 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.

[jj]

Thanks Randy

Unfortunately it doesn't work :-(

/Jj
"Randy Harris" <pl****@send.no.spam> skrev i en meddelelse
news:dn*******************@newssvr13.news.prodigy. com...

* 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.

[PBsoft]

> "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

Try to change that line in the batch file, preceding it with the CALL batch
statement.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution

[david epsom dot com dot au]

Yes, Access does not work well with AT.

Either use a different scheduler (which will allow
you to run as a full user), or don't use Access.

Speaking of which, why open a GUI using a scheduler?

You probably want to script DAO or ADO, not Access.

(david)

"jj" <[e-mail]> wrote in message
news:44*********************@dread11.news.tele.dk. ..

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

[jj]

Hi david

I need to start a database every night, which (when activated) opens another
database and calls a module where some data is imported calculated etc. Here
after the second database is closed, and compressed by the first database,
which is then closed.

When I schedule it from windows scheduler it works fine, but this method
requires that a specific user is logged on.

I have also tried to use VB NT service, but again i have problems activating
the database.

/jj
"david epsom dot com dot au" <david@epsomdotcomdotau> skrev i en meddelelse
news:44***********************@lon-reader.news.telstra.net...

Yes, Access does not work well with AT.

Either use a different scheduler (which will allow
you to run as a full user), or don't use Access.

Speaking of which, why open a GUI using a scheduler?

You probably want to script DAO or ADO, not Access.

(david)

"jj" <[e-mail]> wrote in message
news:44*********************@dread11.news.tele.dk. ..

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

[jj]

Hi

Thanks for your answer, but I'm not sure what you mean - do you mean That I
should just write: call "C:\Programmer\Microsoft
Office\OFFICE11\msaccess.exe" "C:\TestDB.mdb"
Instead of
"C:\Programmer\Microsoft Office\OFFICE11\msaccess.exe" "C:\TestDB.mdb"
?

/jj
"PBsoft" <in**@REMOVEpbsoft.it> skrev i en meddelelse
news:87**************************@news.tin.it...

"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

Try to change that line in the batch file, preceding it with the CALL
batch statement.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution

[PBsoft]

> Thanks for your answer, but I'm not sure what you mean - do you mean

That I
should just write: call "C:\Programmer\Microsoft
Office\OFFICE11\msaccess.exe" "C:\TestDB.mdb"
Instead of
"C:\Programmer\Microsoft Office\OFFICE11\msaccess.exe" "C:\TestDB.mdb"
?

Yes.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution

[david epsom dot com dot au]

> When I schedule it from windows scheduler it works fine, but this method

requires that a specific user is logged on.
Yes, Access requires that a specific user is logged on. You can't
use AT because it does not provide that capability.

It sounds like you should be using DAO or ADO/ADOX to import,
calculate, and compress.

(david)

"jj" <[e-mail]> wrote in message
news:44*********************@dread11.news.tele.dk. .. Hi david

I need to start a database every night, which (when activated) opens
another database and calls a module where some data is imported calculated
etc. Here after the second database is closed, and compressed by the first
database, which is then closed.

When I schedule it from windows scheduler it works fine, but this method
requires that a specific user is logged on.

I have also tried to use VB NT service, but again i have problems
activating the database.

/jj
"david epsom dot com dot au" <david@epsomdotcomdotau> skrev i en
meddelelse news:44***********************@lon-reader.news.telstra.net...

Yes, Access does not work well with AT.

Either use a different scheduler (which will allow
you to run as a full user), or don't use Access.

Speaking of which, why open a GUI using a scheduler?

You probably want to script DAO or ADO, not Access.

(david)

"jj" <[e-mail]> wrote in message
news:44*********************@dread11.news.tele.dk. ..

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

[jj]

Hi David

Thanks for your answer. I'm not realy sure what you mean - can you specify
it a little bit, or give me a hint to where I can find some examples.?

/jj
"david epsom dot com dot au" <david@epsomdotcomdotau> skrev i en meddelelse
news:44***********************@lon-reader.news.telstra.net...

When I schedule it from windows scheduler it works fine, but this method
requires that a specific user is logged on.

Yes, Access requires that a specific user is logged on. You can't
use AT because it does not provide that capability.

It sounds like you should be using DAO or ADO/ADOX to import,
calculate, and compress.

(david)

"jj" <[e-mail]> wrote in message
news:44*********************@dread11.news.tele.dk. ..

Hi david

I need to start a database every night, which (when activated) opens
another database and calls a module where some data is imported
calculated etc. Here after the second database is closed, and compressed
by the first database, which is then closed.

When I schedule it from windows scheduler it works fine, but this method
requires that a specific user is logged on.

I have also tried to use VB NT service, but again i have problems
activating the database.

/jj
"david epsom dot com dot au" <david@epsomdotcomdotau> skrev i en
meddelelse news:44***********************@lon-reader.news.telstra.net...

Yes, Access does not work well with AT.

Either use a different scheduler (which will allow
you to run as a full user), or don't use Access.

Speaking of which, why open a GUI using a scheduler?

You probably want to script DAO or ADO, not Access.

(david)

"jj" <[e-mail]> wrote in message
news:44*********************@dread11.news.tele.dk. ..
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

[pietlinden]

you might check out workspace and opendatabase in the help...

[david epsom dot com dot au]

for example, using VBS

dim dbe
dim db
set dbe = createobject("dao.dbengine.36")
set db = db.opendatabase("a.mdb")
db.Execute "MyAppendQuery"
dbe.CompactDatabase "a.mdb","b.mdb"

(david)
"jj" <[e-mail]> wrote in message
news:44*********************@dread11.news.tele.dk. ..

Hi David

Thanks for your answer. I'm not realy sure what you mean - can you specify
it a little bit, or give me a hint to where I can find some examples.?

/jj
"david epsom dot com dot au" <david@epsomdotcomdotau> skrev i en
meddelelse news:44***********************@lon-reader.news.telstra.net...

When I schedule it from windows scheduler it works fine, but this method
requires that a specific user is logged on.

Yes, Access requires that a specific user is logged on. You can't
use AT because it does not provide that capability.

It sounds like you should be using DAO or ADO/ADOX to import,
calculate, and compress.

(david)

"jj" <[e-mail]> wrote in message
news:44*********************@dread11.news.tele.dk. ..

Hi david

I need to start a database every night, which (when activated) opens
another database and calls a module where some data is imported
calculated etc. Here after the second database is closed, and compressed
by the first database, which is then closed.

When I schedule it from windows scheduler it works fine, but this method
requires that a specific user is logged on.

I have also tried to use VB NT service, but again i have problems
activating the database.

/jj
"david epsom dot com dot au" <david@epsomdotcomdotau> skrev i en
meddelelse news:44***********************@lon-reader.news.telstra.net...
Yes, Access does not work well with AT.

Either use a different scheduler (which will allow
you to run as a full user), or don't use Access.

Speaking of which, why open a GUI using a scheduler?

You probably want to script DAO or ADO, not Access.

(david)

"jj" <[e-mail]> wrote in message
news:44*********************@dread11.news.tele.dk. ..
> 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
>
>