1

So far, my own research shows two options:

  1. CREATE PROCEDURE statement: Close, but limited to a single SQL statement in execution.
  2. Create a Data Macro: Which is more similar to "Triggers" in MS SQL Server.

Is there another way other than the ones listed above?

alextansc
  • 4,626
  • 6
  • 29
  • 45

1 Answers1

1

Based on phadaphunk's answer here in another SO question:

  1. Simulate a stored procedure using a function. I found a tutorial here. But I haven't tried this approach.

  2. How to use SQL Server Stored Procedures with Microsoft Access using Pass Through Queries.

  3. If you are using MS Access 2010 or above, stored procedures will be listed in the tables tab under Named Macros.

Hope this helps.

Community
  • 1
  • 1
Vignesh Kumar A
  • 27,863
  • 13
  • 63
  • 115
  • 1
    Accepted because it contains two additional approaches which I have not considered. – alextansc Apr 13 '16 at 08:48
  • 1
    The second option, *"import a SQL Server stored procedure into Access"*, is misleading. The linked article talks about *executing* SQL Server stored procedures from Access. Those stored procedures will run on the SQL Server and will only be able to manipulate resources that the SQL Server can "see". There is no way to "import" a (T-SQL) stored procedure into Access and have it run in Access itself. – Gord Thompson Apr 13 '16 at 17:14