Stored Procedures in Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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!
 
Back
Top