scheduled accecss procedures (W2k, Office 2k)

Topic

New Reply

Hello loungers
I have a procedure in Access that fires a query and then runs up Outlook and sends a bunch of eMails.
I was hoping to run a scheduled event with windows scheduler that ran up access, ran the query and the eMails.
the vbs script follows, more or less from WOW
—————————-
Dim objAccess

Dim strDBName

Set objAccess = WScript.CreateObject(“Access.Application”)

strDBName = “x:pathName:databaseName.mdb”

objAccess.OpenCurrentDatabase strDBName
objAccess.docmd.runMacro(“sendAlerts”)

—————————-
The macro sendAlerts runs the procedure which executes a query and fires outlook.

My problem is that the windows installer runs and tries to update MSOffice .. ????
THere may well be a bigger problem in that the approach is all wrong.

Any thoughts from you folk would be appreciated

Geof

Reply | Quote

Replies

What happens if you start Access by itself? Do you get the installer too? What if you let it update Office?

Reply | Quote

Hello Hans
I let the update run and all is well.
The scheduler runs perfectly, access fires and in turn fires outlook perfectly.
I might explore running the code by means other than

objAccess.docmd.runMacro(“sendAlerts”)

but it works.

Thanks for the interest

Geof

Reply | Quote