I need to Automate Access, from Excel and have Access automaticly quit, if it's left open, for more than two minutes.
I'm somewhat familiar with automating word, from Excel, or Excel, from VB, but have never Automated Access.
VB Code:
  1. Dim AccApp As Access.Application
  2. Set AccApp  = New Access.Application
  3. AccApp .OpenCurrentDatabase strPath
  4. AccApp.Run strMyprocedure
  5. 'some sort of timer, for pausing(accuracy, isn't important)
  6. 'close & quit(need command's for closing with, & without, saving)
Thanks in advance