Results 1 to 2 of 2

Thread: 'Stored Procedures' in MDB

  1. #1
    Join Date
    Sep 2004
    Posts
    2

    'Stored Procedures' in MDB

    Hello to all,

    AFAIK there are no 'Stored Procedures' (SP) availible in an MSAccess MDB, aren`t they?

    Is there a way to simulate them? Perhaps through custom VBA-Functions?
    Even 'Parametrized SP'?

    I need to query an MDB (used by another app) on another PC via ODBC.
    To limit traffic and usage, i`d like to use SP.

    Any way to do this?
    Anyone knows a good Manual or Tutorial??

    Thanks in Advance.
    HaFritz

  2. #2
    Join Date
    Sep 2004
    Location
    Shropshire, England
    Posts
    1
    Hi Hafritz

    I encountered a similar problem to yours. After extensive searches I discovered that it is indeed possible to create a stored procedure in Access 2002 onwards. However, since there is only 1 page in MSDN about it, it is clearly an "undocumented" feature that is not recommended.

    The VBA code example in the relevant MSDN page also makes the whole business look very unattractive! However, you may be more adventurous than me, so search MSDN for "Access" and "Stored Procedure" and see what you think.

    Personally, I'm migrating the back-end of my application to MSDE 2000 which is free(!) with Office 2000 Professional onwards, integrates seamlessly with Access 2000 onwards, and handles stored procedures properly.

Posting Permissions

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