Hi,

iam facing a peculiar problem, i had developed web
application using ASP and MS-Access as database. and
this application will be used on the intranet server
and it will act as thin client
complete application is working fine on my standalone
system , select,update and insert data functions are
working fine.
but when i uploaded this application on local Intranet
server, asp pages with update and insert functionality
are throwing error.

error1: Use updateable query.
error2: Database or object is read only.


i had changed the properties of .mdb file from Read
only to normal ones, even after this same error is
thrown and i cant update database.

##Sample of Update Statement Used ##

cn.Execute "update  trynewinnovations set
scanngcomments='"&cm&"',Status
'"&st&"',deptconc='"&dpt&"',InnovationType='"&itype&"'
 Where ProposalNumber = "&strn&" " 

######################################


what might be error.

your early response will be appreciated.

syed 

__________________________________________________
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/

You need to change the NTFS permissions on the server. The anonymous
internet user needs appropriate permissions to the folder that the .mdb file
is in, and the .mdb file itself. Change (RWXD) is enough.

Also, if that doesn't fix the problem, make sure that the Sys Administrator
hasn't tightened permissions on the system temp directory (winnt\temp), the
Jet engine puts its temporary working files in that folder.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "syed moiz" <sa_moiz@y...>
Subject: [access_asp] file path problems


: iam facing a peculiar problem, i had developed web
: application using ASP and MS-Access as database. and
: this application will be used on the intranet server
: and it will act as thin client
: complete application is working fine on my standalone
: system , select,update and insert data functions are
: working fine.
: but when i uploaded this application on local Intranet
: server, asp pages with update and insert functionality
: are throwing error.
:
: error1: Use updateable query.
: error2: Database or object is read only.
:
:
: i had changed the properties of .mdb file from Read
: only to normal ones, even after this same error is
: thrown and i cant update database.
:
: ##Sample of Update Statement Used ##
:
: cn.Execute "update  trynewinnovations set
: scanngcomments='"&cm&"',Status
: '"&st&"',deptconc='"&dpt&"',InnovationType='"&itype&"'
:  Where ProposalNumber = "&strn&" "
:
: ######################################

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

hi ken,

thanks for the quick response, i will check out the
changes and i will mail u if theres any problem
bye
Syed

--- Ken Schaefer <ken@a...> wrote:
> You need to change the NTFS permissions on the
> server. The anonymous
> internet user needs appropriate permissions to the
> folder that the .mdb file
> is in, and the .mdb file itself. Change (RWXD) is
> enough.
> 
> Also, if that doesn't fix the problem, make sure
> that the Sys Administrator
> hasn't tightened permissions on the system temp
> directory (winnt\temp), the
> Jet engine puts its temporary working files in that
> folder.
> 
> Cheers
> Ken
> 
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: "syed moiz" <sa_moiz@y...>
> Subject: [access_asp] file path problems
> 
> 
> : iam facing a peculiar problem, i had developed web
> : application using ASP and MS-Access as database.
> and
> : this application will be used on the intranet
> server
> : and it will act as thin client
> : complete application is working fine on my
> standalone
> : system , select,update and insert data functions
> are
> : working fine.
> : but when i uploaded this application on local
> Intranet
> : server, asp pages with update and insert
> functionality
> : are throwing error.
> :
> : error1: Use updateable query.
> : error2: Database or object is read only.
> :
> :
> : i had changed the properties of .mdb file from
> Read
> : only to normal ones, even after this same error is
> : thrown and i cant update database.
> :
> : ##Sample of Update Statement Used ##
> :
> : cn.Execute "update  trynewinnovations set
> : scanngcomments='"&cm&"',Status
> :
>
'"&st&"',deptconc='"&dpt&"',InnovationType='"&itype&"'
> :  Where ProposalNumber = "&strn&" "
> :
> : ######################################
> 
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 
> 


__________________________________________________
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/