I'm having trouble deleting a row from an access database on an internet server using asp. I can select everything from it just fine but when I go to delete a row this error message comes across:

Microsoft JET Database Engine error '80004005'

Could not delete from specified tables.

Here's the code I'm using to delete a row:


set MyConn = Server.CreateObject("ADODB.Connection")

cnpath= server.mappath("Users.mdb") & ";User Id=admin;Password=;"

Myconn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= "& cnpath

SQL_query = "Delete FROM Company WHERE CompanyID= "& ID

set lRecordSet = MyConn.Execute(SQL_query)



There are no relationships set up either. Any help would be greatly appreciated.