-
Can anyone please help ?
I have a connection to an Access 7.0 database from
the Data Environment using Provider=Microsoft.Jet.OLEDB.3.51
I am using a parameterised command (detailed below) to insert values into a table.
INSERT INTO sickdays (UserID, ADate, Month, Reason)
VALUES (?, ?, ?, ?)
This works fine with the OLE 3.51 provider, however if I use the OLE 4.0 provider - the Insert statement doesn't work.
Can anyone please tell me why, or how to get the same effect with 4.0
Thanks, Daniel.
-
I'm not sure Daniel but I think 4.0 is designed with Access 2000 in mind
-
Try putting brackets around MONTH. Change this
INSERT INTO sickdays (UserID, ADate, Month, Reason)
TO This
INSERT INTO sickdays (UserID, ADate, [Month], Reason)
If the jet 4 engine now recognizes the word 'month' as a special keyword, it will give you an error with your insert statement....
-
A Big Thanks
You are an absolute diamond.
Thanks very much - I really appreciate your help !
Daniel.