Stored Procedure

  • Thread starter Thread starter dave h
  • Start date Start date
D

dave h

Hi,

Is it possible to create/execute a stored procedure with Access 2003 and the
default Jet DB?

Thanks, Dave H.
 
Hi,


A parameter query is a one line code store procedure. You can't produce a
multiple line (multiple SQL statement) procedure, but a single line, sure.
Either as a parameter query, either with a CREATE PROC.


Hoping it may help,
Vanderghast, Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
Access pass-through query to Oracle 10g stored procedure - results 1
SQL Stored Procedure 1
How to invoke a sql stored procedure from ACCESS 6
how can i convert stored procedures in sql to stored queries in ac 1
Pass Through Queries (Access 2002) 2
Stored Procedure: Insert row and retrieve scalar value as a result. 1

Back
Top