Excute multiple delete and insert statements in same query
Posted on 2007-10-08
Is there a way to execute multiple delete or insert statements in an Access query? Think of this as an equivalent to a sql server stored procedure.
I have a database in sql server that is used by a windows app. I want to package the database with the windows application installation, so I exported it to Access. The problem is that I have several stored procedures, the functionality of which I need to reproduce. Two of the sps have multiple delete and insert statements I want to replicate in Access; hence, the question above.
P.S. I realize I could simply execute each delete and insert statement from the windows app, but I would like to know if there is a better way.