Search code examples
sqlms-accessprocedure

Syntaxerror in CREATE TABLE without any table creation but in procedure creation

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

error with code

Solution

  • Microsoft Access 2003 does not support stored procedure as sql. You can use Microsoft Access Procedure Creation for creating the same