4 Replies - 824 Views - Last Post: 28 November 2012 - 03:23 PM Rate Topic: -----

#1 hwoarang69  Icon User is offline

  • D.I.C Head

Reputation: -1
  • View blog
  • Posts: 171
  • Joined: 23-October 12

create table help

Posted 28 November 2012 - 03:15 PM

trying to create table in Access2007.

CREATE TABLE user
(id int(8),
last Text(25),
first Text(20),
class Text(10),
dob Date);


but table is not being created.

This post has been edited by hwoarang69: 28 November 2012 - 03:57 PM

Is This A Good Question/Topic? 0
  • +

Replies To: create table help

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9365
  • View blog
  • Posts: 35,178
  • Joined: 12-June 08

Re: create table help

Posted 28 November 2012 - 03:18 PM

Errors - did you get one?
Was This Post Helpful? 0
  • +
  • -

#3 hwoarang69  Icon User is offline

  • D.I.C Head

Reputation: -1
  • View blog
  • Posts: 171
  • Joined: 23-October 12

Re: create table help

Posted 28 November 2012 - 03:19 PM

ERROR:
query must have at least one destination field.
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9365
  • View blog
  • Posts: 35,178
  • Joined: 12-June 08

Re: create table help

Posted 28 November 2012 - 03:21 PM

... okay so what's the query look like? I am not believing that create table is all of it.
Was This Post Helpful? 0
  • +
  • -

#5 hwoarang69  Icon User is offline

  • D.I.C Head

Reputation: -1
  • View blog
  • Posts: 171
  • Joined: 23-October 12

Re: create table help

Posted 28 November 2012 - 03:23 PM

this is 2nd query to give it primarykey:


CREATE INDEX PrimaryKey
ON user(id) WITH PRIMARY
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1