Schedule a Access app to execute automatically

[Guest]

Hi,

I have access application which gets the data from Excel sheets and upload
to the Oracle.

I have to automate the whole process in the background. The process should
execute automatically and complete its job.

Is there any way we can make it possible to start the application at some
specific time to do the job?

Thanks in advance for your help.

 

[Steve]

You can use the Windows Task Scheduler to start your Access application at a
time(s) you specify. You could then use an autoexec macro in your Access
application to automatically run your code.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

Thanks Steve.

I will give a shot.

Do you have any link or example?

Really appreciate your help.

Regards,

 

[Steve]

Look up TaskManager in the Windows Help file and lookup Autoexec Macro in
the Access Help file.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)