I am trying to insert a record into a table that includes 3 fields:

Name Data type

ID AutoNumber
Date Date/Time
ServiceID Number

Any of the following commands:

INSERT INTO NurseryEvent (Date, ServiceID) VALUES ('1/1/2003',1)

INSERT INTO NurseryEvent (ID, Date, ServiceID) VALUES (NULL,'1/1/2003',1)

INSERT INTO NurseryEvent (ID, Date, ServiceID) VALUES (DEFAULT,'1/1/2003',1)

result in:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

If I create a test table with no AutoNumber field, the INSERT command works just fine.

Any suggestions

__________________
Ego is a faithful friend; He stays with us all the way to the crater.

Never mind.

Apparently, it is the field named "Date" that is screwing me up.