Operation must use an updatable query

[papakula]

Hi all!
I am using access database with dsn calling thru asp pages. Its working well in retrieving records, but I am not able to update/delete records as its giving the error

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

Could You please help me out

 

[snowboardr]

Your permissions are off.. right click the db, and check off read-only.. also check folder permissions for the folder that that db is in.. goto the security tab under properties, and make sure that folder has write permissions. www.vzio.com
ASP WEB DEVELOPMENT

 

[papakula]

Thanks!
But where do I do this changes, do I need to do on my system or at my domain address place

 

[snowboardr]

On the system that has the database. www.vzio.com
ASP WEB DEVELOPMENT

 

[papakula]

Hi,
I am still getting the same error. I had selected the directory in which my databse is stored and gone to its properties. As my system is on Win Xp, I got 4 tabs
like General, Sharing,Web sharing,Customize. Then I had selected Web sharing from that and I clickd on Edit properties inthat and selected read/write etc. But I am unable to goto properties of .mdb file as when I right click on mdb its not having this properties. After doing this I tried to insert thru my webpage , its still giving the same error. What I need to do next

 

[TonyU]

[tt]
Can we see the update code, the answer might be in the code you're using. [tt]
^{"A Successful man is one who can build a firm foundation with the bricks that others throw at him"}
[/tt]

​

 

[snowboardr]

On Windows XP the security tab isn't there, because you have to be on a work group or something stupid like that.. I have never been able to solve this problem with Access/ permissions, so I just switched to MySQL database and had no problems. With update, delete, select, etc.. www.vzio.com
ASP WEB DEVELOPMENT

 

[papakula]

Hi
Thanks for your help. This is the code I am using its working perfectly on my system. I cannot use dsn-less connection as my provider doesnt support that.
Could you please help me to sort it out.


<%
Dim strDb
Dim strConn

'this procedure is called wherever a connection is needed.
sub openConn()
'use appropriate connection string
set strdb=Server.CreateObject(&quot;ADODB.Connection&quot
strConn=&quot;DSN=TCard&quot;
strdb.Open strConn
'Dsn=TCard

end sub
call openconn()
strSQL=&quot;select * from country&quot;
set rs=server.createobject(&quot;adodb.recordset&quot
with rs
do while not .EOF
response.write rs.Fields(0)
.MoveNext
loop
end with


sub closeConn()
if isobject(strDb) then
if strDb.State = adStateOpen then
strDb.Close
end if
set strDd = nothing
end if
end sub

%>