Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    3

    Unanswered: Does something like stored procedures exist for Access?

    I have an Access database on one computer and a Visual Basic application on a second one. The Visual Basic application uses ADO to connect to the database.

    I was wondering if Access has something like parameterized stored procedures that I could pass arguments to rather than use sql statemtents in ADO commands?

    I am wanting to eliminate some of the overhead on the network by calling a "stored procedure" like what is done with SQL Server.

    Thanks

  2. #2
    Join Date
    Jul 2002
    Posts
    67
    I don't believe Access has "Stored Procedures" as SQL Server does. The closest thing you will get to stored procedures in Access is creating a query using the Query Builder and calling that query you built within your application.
    Don't do today, what can be done tomorrow.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •