Run Time Error 2147467259 Could Not Find File

Hi
I am running Access 2000 with MDAC 2.8 and SQL Server 2000 database. I have linked the tables of the database in Access. The problem is that it would not allow me to insert/update/delete but only to select from the database.

Here is the code:
Dim strSQL As String
Dim con As ADODB.Connection
Dim cmd As ADODB.Command

Set con = CurrentProject.Connection
Set cmd = New ADODB.Command

Set cmd.ActiveConnection = con

strSQL = " INSERT INTO dbo.crop_demand_yearly (" & _
"geo_id, crop, area, water_value, water_use, date_from, date_to)" & _
" VALUES("

strSQL = strSQL & ((Val(Me.txt_borenid))) & "," & (Val(Me.cbo_crop)) & "," & (Me.txt_area) & "," & (Me.txt_use) & "," & (Me.txt_value) & ",'" & Format(Me.txt_datefrom, "dd/MM/yyyy") & "','" & Format(Me.txt_dateto, "dd/MM/yyyy") & "')"


cmd.CommandText = strSQL

cmd.Execute strSQL


con.Close
Set cmd = Nothing
Set con = Nothing

I dont understand what is the problem! Please help