Post reply

Start SQL code through Access

  • April 12, 2007 at 8:33 am

    #370488

    Does anyone know if it is possible to kick off some SQL code through an Access query or some other Access application?

  • April 12, 2007 at 10:52 am

    #700155

    Yes it is.

    I normally create stored procedures in SQL Server or if I have a job in SQL Server, I would refer to sp_start_job

    http://msdn2.microsoft.com/en-us/library/ms186757.aspx

    Then from Microsoft Access I use ADO in a module and execute stored procedures. In access if you have a module I think you can call it as a function from your queries too.

    Regards,Yelena Varsha

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply