Insert Issue into Acces DB
I am having a problem with the insert of the following code. I am getting the error:
"Data Type Mismatch in Criteria Expression"
I think the issue is with the Date but I don't know what I need to do to correct it.
Code:
Dim Project As String = Guid.NewGuid.ToString.ToUpper()
Dim Program_Name As String = "BRX999B"
Dim Turnover_date As Date = Now()
Dim objCommand As OleDbCommand = New OleDbCommand
'intPosition = objCurrencyManager.Position
objConnection = New OleDbConnection(strConnectionString)
objConnection.Open()
objCommand.Connection = objConnection
objCommand.CommandText = "Insert into Projects" & _
"(PDF_Number, Programs, Test_Plan, Turnover_date)" & _
"Values(@PDF_Number, @Programs, @Test_Plan, @Turnover_date);"
objCommand.Parameters.AddWithValue("@PDF_Number", Project)
objCommand.Parameters.AddWithValue("@Programs", Program_Name)
objCommand.Parameters.AddWithValue("@Test_Plan", "C:\Documents and Settings\e352532\My Documents\DB\Projects.mdb")
objCommand.Parameters.AddWithValue("@Turnover_date ", Turnover_date)
mfb
mfb
__________________
mfb
|