Automatically run a process at a specific time

[jayes]

Hi,

I need to automate a specific routine at a specific time, I have found the
following article for excel

http://www.cpearson.com/excel/OnTime.aspx

But I need to run this from Access, I havent tried the Win API version yet
but Im searching for an access coding way of doing this??

Thank You

 

[Tom van Stiphout]

One simple solution is to use the Windows scheduler (Control Panel >
Scheduled Tasks) to run your database with the /x command line switch
(see help file for all command line options), which then will start a
macro which will run the code you want to run.

-Tom.

 

[jayes]

Thanks I will give that a try..

I have found kb article q125772 , Does anyone know if there is there an
update to this article for access 2000 and am i correct in assuming that
this will be able to run a procedure at a set time?

Thanks again

 

[Jeff C]

--
Jeff C
Live Well .. Be Happy In All You Do

Thanks I will give that a try..

I have found kb article q125772 , Does anyone know if there is there an
update to this article for access 2000 and am i correct in assuming that
this will be able to run a procedure at a set time?

Research Access Command Line switches. Use of the command line switch that
calls a macro is what you need as referenced earlier by Tom. Whatever
process you wish to run needs to be built in an access macro. You then
attach the command line calling the macro to a task in the task scheduler set
to run at a specific time.

 

[jjj]

Thanks I will go with this route.


But i am having aproblem with using docmd, I am trying to runa make table
query getting info from a sybase linked table unfortunaetly it keeps asking
for a password, username is filled in , server is filled out and server name
is filled out but not password. I have noticed that if i am the last person
to enter the password then close database and go back in it does not prompt
me for the password. but this obviusly is nto practical as many users open
database.


Many thanks

 

[Jeff Boyce]

You mention a linked table.

It is possible, during the linking process, to specify username and password
and to "remember" these (at least for some varieties of linked tables).
Have you tried re-linking (i.e., delete the current links, re-establish the
links) and seeing if you have this feature for your Sybase tables? NOTE:
work from a backup copy!

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[jjj]

Thanks for replying Jeff,

Yes I have deleted the linked tables, linked via odbc(right click - link
table, choose odbc and then using linked table manager afterwards, yes it is
odd that i have said save password.. but it does not..

this i must say is a real pain becuase ianother problem im having is perhaps
on a daily basis i have to delete all the linked tables and readd them
before i run the query. - a real pain!

 

[Jeff Boyce]

I don't have any direct experience working with a Sybase back-end. Perhaps
one of the other folks here can clarify how Sybase treats links...

Good luck!


--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/