In Access, the 'text' field is really called 'varchar'.  The following
statement should work for you.  Text fields are really memo fields and have
a set length of 16.

CREATE TABLE EventLog3
(
  ID COUNTER
  CONSTRAINT ID PRIMARY KEY,
  Domain varchar(40),
  IP varchar(40),
  Action varchar(10),
  xDate DATE,
  Info varchar(255)
)

---
Daniel Dewey                |"You can reason with ignorance, 
Unix/Internet SysAdmin      | but you can not argue with 
MCP (NT srvr/wkstn/eprise)  | stupidity."
[EMAIL PROTECTED]          |  -- Unknown

http://www.pobox.com/~dewey |                 610-868-1421, x115
           The National Association of Colleges and Employers

     These opinions are mine, and may not be the same as my employer 
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Reply via email to