Run a stored procedure in MS-Access from windows task scheduler in VB.Net

Hi there all experts,
                            I have a application with MS-Access as the back end. There are some queries I would like to run using the windows task scheduler if it's possible. Thanks for the help in advance.
Who is Participating?
iboutchkineConnect With a Mentor Commented:
Create VB.NET application that will run query and call this application from the scheduler

To run query

        Dim oAccess As Object
        Dim sDB As String = "c:\testdb\db.mdb"
        Dim sQuery As String = "Myqry"

        oAccess = CreateObject("Access.Application")

        ' Open the database
        oAccess.Visible = True
        oAccess = Nothing
wongke9622Author Commented:
Thanks iboutchikne, i will try that soon and let you know
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.