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]