Cannot delete from specified table with ODBC

[datadiva]

Converted Access data to SQL and linked tables via ODBC.
In Access 2000 delete button (code below) runs fine.
Enabled MS-DAO 3.6 in VB References and fixed my user-error not defined problems, but now have 3086 RT Error.
I am sure it is because I need to change something else in the vb code reference, but what???

Note: Will compensate for first correct answer !!!

Here is the code:
----------------------
Private Sub Command194_Click()

Dim dbs As DAO.Database
Set dbs = CurrentDb()
Dim lot
Dim project
Dim candle
lot = Me.nLotNbr
project = Me.nProject
candle = Me![Child103]![nCandleNbr]

Response = MsgBox("Are you sure you want to Delete this Candle and all Observations for it. ", vbYesNo)

If Response = vbYes Then
''' *** CODE BREAKS HERE ***
dbs.Execute ("DELETE * FROM TBLLC WHERE nlotnbr like '" & lot & "' AND nproject = " & project & " And ncandlenbr = " & candle)
dbs.Execute ("DELETE * FROM TBLLCOS WHERE nlotnbr like '" & lot & "' AND nproject = " & project & " And ncandlenbr = " & candle)
dbs.Execute ("DELETE * FROM TBLLCOA WHERE nlotnbr like '" & lot & "' AND nproject = " & project & " And ncandlenbr = " & candle)
Me![Child103].Requery

MsgBox ("Delete Successful&quot
ElseIf Response = vbNo Then
MsgBox ("Candle NOT Deleted&quot
End If

End Sub

 

[Darrylles]

Hi,

Does this help?

http://www.experts-exchange.com/Developer/Databases/MS_Access/Q_20383518.html

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."