Thread: MS Access Stored Procedures?

Just to prove that I'm not an Access developer, I posit the following:

Is there an equivalent to an SQL Server Stored Procedure in MS Access? Apart from a Stored Query that is.

For example, could the following sproc be replicated in MS Access

Code:

Create Procedure Foo as

      Declare @A int;
    
     Begin Transaction
      Select @A = FieldA
        From someTable
        Where FieldB = 'some search cirteria';
 
      If @A is not Null 
         Insert Into someOtherTable
           Select FieldX, FieldY, FieldB
            From yetAnotherTable
           Where yetAnotherTableID = @A

     If [some more statements] = 'did not work' Begin
         Rollback Transaction;
         return
     End

    Commit Transaction
Return

Not really, since Access is just a file-server, not a true client-server like SQL Server. In other words, the database manipulation is done in the Access client. The database back-end is effectively just the data storage medium.

OK, so that would explain why I see some really interesting programs.

What about Transactions? Does Access support those?

Access has some "transaction" features in VBA, where you can start and end transactions, commit or roll back, but they are not inherent in the Jet database engine, itself. There's a good discussion of this and similar issues at Microsoft Access - Wikipedia, the free encyclopedia