Unable to delete , update, or add to DB

[crashc123]

Was working last week and now I get messages like.....
for delete
Microsoft JET Database Engine (0x80004005)
Could not delete from specified tables.
command is
Set cnnDBEdit = Server.CreateObject("ADODB.Connection&quot
cnnDBEdit.Open CONN_STRING
cnnDBEdit.Execute strSQL, adAffectAll, adExecuteNoRecords

or
for Edit
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
Command is
Set cnnDBEdit = Server.CreateObject("ADODB.Connection&quot
cnnDBEdit.Open CONN_STRING
Dim adAffectAll
cnnDBEdit.Execute strSQL, adAffectAll, adCmdText or adExecuteNoRecords

or
for add
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
command is
Set rstDBEdit = Server.CreateObject("ADODB.Recordset&quot
rstDBEdit.Open strSQL, CONN_STRING, adOpenKeyset, adLockOptimistic, adCmdText


Have check properties on Access DB and they all look right. I even used windows explorer to check the properties of the DB file and are set for archiving. I even went back to a copy of the web I had on another computer. Counldn't run the web on the other computer since I had no server set up on it, but it was a copy of the one that worked last week.

Any Ideas would be helpful.

 

[DirtyB]

You need to make sure that your IUSR has permissions on the folder where your mdb resides, and on the mdb itself. The IUSR Guest will need everything but full control.

 

[crashc123]

Thank you very much, but I am not sure how to do that? The IUSR part.

 

[DirtyB]

Well, if you're using IIS, and hitting an Access database from an ASP page, then this is your solution. The IUSR (internet guest account) is the account that people using your ASP page will be hitting your database under. Therefore this account needs to be able to change/add/delete things from your Access database. You can look at the properties of the folder your database lives in and add the IUSR and give them rights to it.