January 7th, 2005, 07:34 PM
|
|
Registered User
|
|
Join Date: Jan 2005
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
IIS 5.1 MS Access, ASP.NET write permissions
Hi there,
I desperately need help to configure IIS 5.1 to grant write permission to ASP.NET application to MS Access database.
I have following configuration
Win XP professional
IIS 5.1
ASP.NET
MS Access
I can access database fine but when I want to delete/update database I get following error/message
Exception Details: System.Data.OleDb.OleDbException: Could not delete from specified tables
I am a newbie and don't know how to grant write permission. Please help, I am trying to resolve this issue for the last 3 days 
Code:
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Page Language="VB" Debug="true" %>
<script runat="server">
sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath("Emails.mdb"))
dbconn.Open()
sql="DELETE FROM List where email='somemail@yahoo.com'"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteNonQuery()
dbread.Close()
dbconn.Close()
end sub
</script>
<html><body>
Mission Accomplished
</body></html>
Your help is greatly appreciated.
Judy
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
