Skip to content
Advertisement

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

Advertisement

Answer

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

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement