I have an ASP site I created with Microsoft Access on a Personal 

Web Server at home.  It lists, updates, deletes and adds records to 

the database using forms.  At home it works beautifully, but when I 

FTP it to it's final destination on the net, the delete, add and update 

functions bring up an error - 



"Microsoft OLE DB Provider for ODBC Driverserror '80004005' 

[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an 

updatable query. "



Am I missing some kind of code that is necessary for the program to 

run properly on the internet?  Like I said, it works fine at home.  And 

it lists the database fine online, but that's about it.  The website can 

be found at -  www.utahpianos.com/editroom.asp .  If you would like 

to see the code, let me know and I'll email it to you, it's a rather long 

program.



Thanks in advance.

-Ryan

Is it a permissions problem? Does the anonymous internet user

(IUSR_<machinename>) have the necessary privaleges on the server to modify

the .mdb file?



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Ryan G. Passey" <rgpassey@h...>

Subject: [access_asp] works at home, but not online





: I have an ASP site I created with Microsoft Access on a Personal

: Web Server at home.  It lists, updates, deletes and adds records to

: the database using forms.  At home it works beautifully, but when I

: FTP it to it's final destination on the net, the delete, add and update

: functions bring up an error -

:

: "Microsoft OLE DB Provider for ODBC Driverserror '80004005'

: [Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an

: updatable query. "

:

: Am I missing some kind of code that is necessary for the program to

: run properly on the internet?  Like I said, it works fine at home.  And

: it lists the database fine online, but that's about it.  The website can

: be found at -  www.utahpianos.com/editroom.asp .  If you would like

: to see the code, let me know and I'll email it to you, it's a rather long

: program.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

It may very well be a permissions problem, but I do now know how to change 

permissions to fix it.  If it was a coding problem, then it wouldn't work 

on my home computer.  How can I change the permissions, and what should I 

change them to?



-Ryan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Ryan G. Passey" <rgpassey@h...>

Subject: [access_asp] Re: works at home, but not online





: It may very well be a permissions problem, but I do now

: know how to change permissions to fix it.  If it was a coding

: problem, then it wouldn't work on my home computer.  How can

: I change the permissions, and what should I change them to?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



If it's not your machine speak to the server administrator. They'll probably

need to change the NTFS permissions for the file to something like RW

(read/write), and for the folder to RWD (read/write/delete).



From what I understand, most hosting companies that offer ASP/ADO/Access

support give you a designated folder that has those permissions set up

properly, and you stick you databases into that folder...the folder is also

setup so that an anonymous can't download your file by just typing in the

name of the database into the browser window.



Cheers

Ken