Access form calling a stored procedure

  • I have a button as soon as I click on it, I need: How can I call a store procedure in the form? Name of the store procedure sp_DeletetblCust, Server Name:Server1, DatabaseName:List

    Thank you

  • Moved to the Access forum.

    http://www.access-programmers.co.uk/forums/showthread.php?t=34132

  • Your best bet is going to read up on using the ADO command object. It's by far the easiest way to execute a remote SP from a traditional MDB file.

    You will have other options if you are using an Access Data Project.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

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

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