View Single Post
  #5 (permalink)  
Old October 21st, 2003, 01:45 PM
katsarosj katsarosj is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , .
Posts: 540
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Sorry,

Maybe I misunderstood...

If you want to create database tables in Access, try something like:

CREATE TABLE tblname
([Column1 Name] datatype, Column2Name datatype, Column3Name datatype);

To add a primary key:

CREATE TABLE TABLENAME
([Column1 Name] integer CONSTRAINT colIdx PRIMARY KEY, Column2Name text(25), Column3Name text(100));
INSERT INTO TABLENAME VALUES(integer_value, text_value, text_value);

I think this is correct, but been a while since I created Access tables in code.

Hope this helps and is what you are looking for.

J