I’m using Microsoft Access 2003, new to SQL tho. I have no idea why this wouldn’t work, google won’t help me either. The table “K_Lehrer” exists, and the code I have here is the only thing I wrote.
My code is
CREATE PROCEDURE testprocedure AS BEGIN SELECT * FROM K_Lehrer END
Error (translated):
syntax error in create table statement
Advertisement
Answer
Microsoft Access 2003 does not support stored procedure as sql. You can use Microsoft Access Procedure Creation for creating the same