Ok, here's my new problem.
I got to the part about deleting entries. What I did was moved the database to a private directory outside of the wwwroot directory. It is now in C:\Inetpub\Databases and reading and adding works just fine. I'm getting this error while trying to delete:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.
/delete_entry.asp, line 17
and this is the complete delete_entry.asp file:
<%
Dim adoCon
Dim rsDeleteEntry
Dim strSQL
Dim lngRecordNo
lngRecordNo = CLng(Request.QueryString("ID"))
set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("..\Databases\guestbook.mdb")
Set rsDeleteEntry = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblComments.* From tblComments WHERE ID_no=" & lngRecordNo
rsDeleteEntry.LockType = 3
rsDeleteEntry.Open strSQL, adoCon
rsDeleteEntry.Delete
rsDeleteEntry.Close
Set rsDeleteEntry = Nothing
Set adoCon = Nothing
Response.Redirect "delete_select.asp"
%>
It can't be anything to do with permissions since I can add to the database just fine.
Thanks,
~Darxide
Topic Options
Post Options
Thanks(0)
