I need to add and delete information from the database based on information
entered through an HTML form. I have been able to run queries to display
data using the HTML form, but when I attempt to delete a record, I
experience the error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] Couldn't delete from specified
tables.
/completed.asp, line 51
I believe the query is correct. I have had the script print the query
itself to the screen, and it looks fine. Are there some permissions issues
that I have to set up to allow modification of the database? Below is the
section of my ASP that it chokes on:
<% OBJdbConnection.Open "BMW"
sql1 = "Delete from Customers where Number = '" & ValueFromForm & "'"
OBJdbConnection.Execute(sql1) %>
BMW is the name of my System DSN
ValueFromForm is a value that is passed from the previous form
Any ideas?
Greg White
Direct NET Communications