Well, if it's any consolation handling dates is a pain regardless of which database you use. In any case, I created a table with the following definition:
CREATE TABLE testing
(item1 INTEGER,
item2 DATE)
;
I them did the following insert:
INSERT INTO testing
VALUES (1, '18/11/1953 04:20:00');
And everything worked fine. Note that in the date (my Bday, BTW) the format is DD/MM/YYYY followed by the time.
What exactly is the error you're getting? Can you post the exact text of the error message. Also, I ran my test using the examples that come with LabSQL--not the toolkit.
Mike...
Oops, just noticed something. You have a column name that is probibly a reserved word "Date". Try your insert as:
INSERT INTO PRODUCTION
VALUES
('Part#1', 2, '10/10/2003 10:10:10 AM')
If there is only those three columns and they the order the data appears is the same as the column order, you don't need the column list. If this works (and it should--I just tried it) I would only view it as a temporary patch. The column name should be changed.
This is also a good reason to not use the Access GUI to create tables. If you tried creating a table like that in SQL you would have gotten an error message. Learning to build tables in SQL code isn't hard and it adds an extra layer of error checking that the GUI apparently doesn't think is important.
If you're interested let me know and I can send you the info on a really good book on SQL...