Rx_
Nothing In Moderation
- Local time
- Today, 14:32
- Joined
- Oct 22, 2009
- Messages
- 2,803
Has anyone run an unattended MS Access applicaiton on a Windows Server on a daily schedule?
Please suggest any methods, HowTo, lessons learned, tips, or suggestions.
I have posted a few informative steps and links. Each of them seem to leave a little bit out. If anyone has suggestions or better instructions, please share.
Option to Purchase: This tool looks like something that would work
http://www.fmsinc.com/microsoftaccess/scheduler/windows-service.htm
Requires an Application.Quit when Access tasks are complete - this closes Access, and it won't make a difference whether you have a form or not. Put the Public Functions it in a module, and have the Autoexec macro with runcode naming the function.
The MSAccess 2010 application will not have a user interface.
It connects to SQL Server with Linked Tables.
It runs a complex rule engine that evaluates expired dates and changes record values.
It runs an Excel Object Model applicaiton that saves on a network drive.
Example .CMD file: (Access 2007)
CODE
start /max "MSAccess" "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\apps\jobs\Nightly.mdb"
1) Ue UNC paths in your database for linked tables. You can add command to your .CMD file to map any required drive letters.
2) If you want the task to tun without being logged on use an admin user to run execute the task.
3) VBA code is running, make sure that the user executing the task has the VBA enabled. The simplest way it to set the Macro Security Level to low.
Microsoft has these steps:
https://support.microsoft.com/en-us/kb/230575/en-us
Please suggest any methods, HowTo, lessons learned, tips, or suggestions.
I have posted a few informative steps and links. Each of them seem to leave a little bit out. If anyone has suggestions or better instructions, please share.
Option to Purchase: This tool looks like something that would work
http://www.fmsinc.com/microsoftaccess/scheduler/windows-service.htm
Code:
Vague general instruction (not tested for Windows Server)
First time set up the Scheduled Task service on the Windows system:
Start->Settings->Control Panel->Administrative Tools->Services->Task Scheduler->Start
In Windows find the Scheduled Tasks program:
Start->Programs->Accessories->System Tools->Scheduled Tasks
In Scheduled Tasks
Add Scheduled Tasks->Scheduled Task Wizard->
Use location of my Shortcut to be run using Wizard
(shortcut file location found from its Properties)
C:\Documents and Settings\UserName\Desktop\Rx
Create a "MSACCESS.EXE" shortcut. Add command line options
"command line startup command line" options for Access:
"/ro" for readonly databases,
"/x macroname",
"/nostartup" for no startup screen,The MSAccess 2010 application will not have a user interface.
It connects to SQL Server with Linked Tables.
It runs a complex rule engine that evaluates expired dates and changes record values.
It runs an Excel Object Model applicaiton that saves on a network drive.
Example .CMD file: (Access 2007)
CODE
start /max "MSAccess" "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\apps\jobs\Nightly.mdb"
1) Ue UNC paths in your database for linked tables. You can add command to your .CMD file to map any required drive letters.
2) If you want the task to tun without being logged on use an admin user to run execute the task.
3) VBA code is running, make sure that the user executing the task has the VBA enabled. The simplest way it to set the Macro Security Level to low.
Microsoft has these steps:
https://support.microsoft.com/en-us/kb/230575/en-us
