Microsoft OLE DB Provider for ODBC Drivers error '80004005'

I transfer a complete website (asp cms) from one host to another ,
I change the domain name but nothing else.

When I try to edit the files from the back office (admin panel )
I get this error :
--------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/info_pages.asp, line 163
----------------------------------------------------------------------

here is a part of the file " info_pages.asp " , hope that will help.

if errr="" then
set conn=server.createobject("adodb.connection")
set rs=Server.CreateObject("adodb.Recordset")
conn.open=dbstring
rs.open sqlstmt, conn -------------------------------------> Line 163
response.redirect "info_pages.asp"
end if
end if
response.write errr
%>


Thanks in advance

 

Check out this thread from microsoft
http://support.microsoft.com/kb/175168

from the 4 options over there, I think the 1st one might be the problem for u as you said everything worked fine with ur earlier host.

 

if you're using access then make sure that file permissions are set on the mdb

 

also make sure you close the file before trying to connect to it via ASP