Post reply

stored procedure in Access db

  • February 24, 2004 at 9:55 pm

    #60080

    How to create and execute stored procedure in Access db

    Thanks.

     

  • February 25, 2004 at 12:00 am

    #495469

    U can use query in access




    My Blog: http://dineshasanka.spaces.live.com/

  • February 25, 2004 at 12:29 am

    #495472

    But after going to query in access, can we create the stored procedure using

    Create Procedure ProName

    Begin

    End

    just as we can do in sql server 2000.

    I have a asp.net frontend page which calls a stored procedure in sql. Now I am converting my db from sql server to access, so i need to know if I can use the stored procedures

    Thanks

  • February 25, 2004 at 2:47 am

    #495486

    Hi, yes u can use "Create Proc As "in vba .. also the Exec statement works from within the VBA. I use ADO for this part : ) hmm now i see u dont use SQL server anymore.. Im not sure if this can be done in access.. only in project surrounding the Procs get vissible in access..

  • February 26, 2004 at 1:59 am

    #495760

    for dreating stored procedure ... Create a new Access Data Page (ADP) and adjust connection on your server (from file >> connection) .. then new queries .. then Design stored Procedure ... then SQL View and write what you want in your SP ( ADP in Access = as if you use EM in SQL )


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • February 26, 2004 at 2:02 am

    #495762

    to execute Stored procedure in Access make a new query .. and in type chose Specific >> (Pass through query) ... then write what you want as if you are on SQL Server .. like (exec SP ) also take care that if you want to pass argument .. you will need to change this path throug query programmatically .. for any other help contact me


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • February 26, 2004 at 2:04 am

    #495763

    also in your Form you can make a connection and command variables and call your SP with them ... and this is the best way to use SP in Access


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • February 26, 2004 at 4:39 pm

    #496049

    if you can use ADP then That will make your life A LOT easier


    * Noel

Viewing 8 posts - 1 through 7 (of 7 total)

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