Running Microsoft Access as a Scheduled Task

by

To the best of my knowledge the shortest path for a Windows Scheduled Task to “do something useful in Access VBA” is:

Create a Public Function (not Sub) in the database. For example:

Option Compare Database
Option Explicit

Public Function WriteToTable1()
    Dim cdb As DAO.Database
    Set cdb = CurrentDb
    cdb.Execute "INSERT INTO Table1 (textCol) VALUES ('sched test')", dbFailOnError
    Set cdb = Nothing
    Application.Quit
End Function

Create a Macro in the database to invoke the function:

Macro.png

Create a Windows Scheduled Task to invoke MSACCESS.EXE with the appropriate parameters

SchedTask.png

In the above dialog box the values are:

Program/script:

"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE"

Add arguments (optional):

C:\Users\Public\schedTest.accdb /x DoSomething

More Related Contents:

  1. VBScript & Access MDB – 800A0E7A – “Provider cannot be found. It may not be properly installed”
  2. Combine values from related rows into a single concatenated string value
  3. What are the rules governing usage of parenthesis in VBA function calls?
  4. Autonumber value of last inserted row – MS Access / VBA
  5. How to get random record from MS Access database
  6. create form to add records in multiple tables
  7. Operation must use an updatable query. (Error 3073) Microsoft Access
  8. How do I force VBA/Access to require variables to be defined?
  9. Hand Install of 64-bit MS Access ODBC drivers when 32-bit Office is present
  10. How to diagnose MS access crashes
  11. “Operation must use an updateable query” error in MS Access
  12. How to restart counting from 1 after erasing table in MS Access?
  13. Equivalent cURL in VBA?
  14. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  15. MS Access trigger?
  16. Insert SQL command with Datetime in MS-Access
  17. Is MS Access (JET) suitable for multiuser access?
  18. VBA procedure to import csv file into access
  19. How to select top 10 in Access query?
  20. ConcatRelated() in Access, using two keys
  21. Concatenating multiple rows into single line in MS Access [duplicate]
  22. Transform multiple rows into columns with unique key
  23. Passing-variable-from-vbscript-to-batch-file with arguments
  24. Determine real cause of ODBC failure (error 3146) with ms-access?
  25. connected combo boxes in continuous form – the second combo doesn’t show its value if dependent on first combo how could I fix that
  26. How to call Run() with parameters
  27. Create sequential ID value based on the year that a record is added
  28. How to use cross join in access?
  29. Get Name of Current VBA Function
  30. How to extract the schema of an Access (.mdb) database?

Leave a Comment