ASP Script Assistance

Greg White ( )
Sun, 20 Jul 1997 13:09:29 -0700

I am writing an ASP page that interacts with an Access database.

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

/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