DDEPoke to MSAccess

Post by **Marcus Tettmar** » Tue Jun 06, 2006 1:21 pm

Ah, I see the problem! Date is a reserved word in Access. It is a function that returns the date, so I think that is confusing it. Put Date in square brackets instead - square brackets are used to identify a table/recordset column in Access. So change your code to this:

INSERT INTO table_tblMain (Cell, ESN, FailCode, Description, [Date]) VALUES ('Cell2','46605485','Passed','Passed','20060512');

e.g.

Code: Select all

'insert into table_tblMain
SQLString = "INSERT INTO table_tblMain (Cell, ESN, FailCode, Description, [Date]) " & _
"VALUES ('" & cell & "', '" & esn & "', '" & fcode & "', '" & descrip & "', '" & date & "');"
MyDB.Execute(SQLString)

Try that.

mydave · Post by **mydave** » Wed Jun 07, 2006 1:44 am

Wow! That [Date] did it.
Much appreciated.

Sorry for the late response. I decided to install 8.0.3 then logged off and logged back in as a client. msch would not compile, giving 'cannot compile due to incomplete installation'. I got to log back in as administrator to test.
Thanks again for the great help.
Cheers