Stored Procedures in Access 2000

G

Guest

Does Access used stored procedures? The SQL engine
recognises the 'PROCEDURE' command but I can't get it to
work. I think that is only for SQL Server.
 
J

John Vinson

Does Access used stored procedures? The SQL engine
recognises the 'PROCEDURE' command but I can't get it to
work. I think that is only for SQL Server.
Click to expand...

Your thinking is correct. Access Projects (.adp files) actually ARE
SQL Server and can use stored procedures, but Access JET .mdb files do
not.

VBA code run from Forms can do almost anything that a stored procedure
can do - the thought process is quite different though!
 

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
SQL Stored Procedure 1
How to invoke a sql stored procedure from ACCESS 6
Pass a parameter to a stored procedure from ms access 2
Stored Procedure Returns No Results 1
stored procedure query 4
how can i convert stored procedures in sql to stored queries in ac 1

Top