Click to See Complete Forum and Search --> : problems with Update...
Hi There.
I have this line:
SQL = "UPDATE newsTBL SET newsTitle='" & newsTitle& "' WHERE id=" & id
And I'm getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
What is wrong in there?
Thanks!
buntine
03-27-2004, 03:39 PM
This error is typical when you dont have full read/write permissions set on the database and the directory it resides in.
The SQL query itself is correct.
Regards,
Andrew Buntine.
worked before.
What can it be other that that?
buntine
03-27-2004, 03:43 PM
This error will also occur when your DB is located outside your web site. If it is not within your inetpub/wwwroot directory, you cannot UPDATE or INSERT records into it.
Also, make sure the DB is not opened at the site the query is executed.
Regards.
Also, make sure the DB is not opened at the site the query is executed.
buntine
03-27-2004, 03:48 PM
It must be closed.... Dont have the DB explicitely opened. If you are not working from your own local server, you dont need to worry about it.
The problem is the fact that you dont have full IUSR priveledges set to read/write.
You will have to contact your server admin to have them set. He/She may have altered them or you may have moved the DB to a different directory.
Regards,
Andrew Buntine.
buntine
03-27-2004, 03:54 PM
You can use one of ASP's built-in components to check whether a certain file has permissions. Relative of the outcome of this script, i still suggest to email your server admin.
dim objPerm
objPerm = Server.CreateObject("MSWC.PermissionChecker")
if objPerm.hasAccess(Server.MapPath("\subDir\yourDB.mdb")) then
Response.write("You have access to this file")
else
Response.write("You DO NOT have access to this file.")
end if
Set objPerm = Nothing
Regards,
Andrew Buntine.
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method