Stored Procedure in Access?

Results 1 to 2 of 2

Thread: Stored Procedure in Access?

  1. #1
    dclark Guest

    Default Stored Procedure in Access?

    I have an SQL update procedure I want to automatically run every night. Does anyone know if this is possible in Access 97?

  2. #2
    Hugo Mejia Guest

    Default RE: Stored Procedure in Access?

    It seems to me that Access97 does not support stored procedures, although you may want to double check with Microsoft!). Nor does it support timed events, unless you call the event through a form that is active at the time you want it to fire the event. This is probably not what you need, because you would need to get the Access application started just before you want the procedure to fire. You would also need to make sure the form with the timed procedure is the active form.<BR>Not a very automatic process, in my opinion!.

Posting Permissions

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