first create table in MS access data definition sql view

**learning_graccess** · 10-14-2011, 04:20 AM

I tried to create my first table using sql in ms access but it failed.

My codes are like below. It was showing "Syntax error in field definition". What could be the problem??

Code:

CREATE TABLE loom
(
column1 integer,
column2 integer,
column3 integer,
);

**orange** · 10-14-2011, 06:23 AM

Remove the last , in your sql.

Also see
http://www.techonthenet.com/sql/tables/create_table.php

first create table in MS access data definition sql view

Thread Tools

first create table in MS access data definition sql view

Similar Threads

Does anyone know how to create a basic data entry form for a table?

Corrupt Table in Data Set View Access 2010

Why does data disappear , return on tabbing, show up in different rows on table view?

Can access have a table view inside a form

Cascading list box look up fields in the table definition not on a form

Posting Permissions