What data type is CategoryID in the table? If it's string (text) then try this...
sql="DELETE FROM Categories WHERE CategoryID = '" & CatID & "'"
If it's numeric (integer) then..
sql="DELETE FROM Categories WHERE CategoryID = " & convert.toint32(CatID)
ALSO:
You NEED to place the following at the top of each code page...
Option Explicit On
Option Strict On
AND:
Declare your variables as types...
these are not: "Dim dbconn,sql, dbcomm,dbread"
it should be something like this...
Dim dbconn as OledbConnection
Dim sql as string
Dim dbcomm as oledbCommand
You should go back to the sample and see how they declared their variables, if the type is SqlConnection then simply replace the Sql with OleDb to get OleDbConnection