hi Ken,

is it necessary to change the security permissions on
WINNT/TEMP
whenever i update the fresh ASP Project Files.
Iam asking this because as u said to me last time i
tried with changing security permissions and Project
worked fine on local intranet server.
and now i have some major changes done to the project
and i had updated files on server but again
update,insert and select queries contained ASP Pages
are not displayed,

ERRORS

### PAGE CANNOT BE FOUND ERROR &
### use updateable query

cant i fix this problem once and for all.

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!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/

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


: hi Ken,
:
: is it necessary to change the security permissions on
: WINNT/TEMP
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Yes. The Jet database engine using the Winnt\Temp directory to store it's
temporary working files. The anonymous internet user account needs
appropriate permissions to this temporary directory

Cheers
Ken


: whenever i update the fresh ASP Project Files.
: Iam asking this because as u said to me last time i
: tried with changing security permissions and Project
: worked fine on local intranet server.
: and now i have some major changes done to the project
: and i had updated files on server but again
: update,insert and select queries contained ASP Pages
: are not displayed,
:
: ERRORS
:
: ### PAGE CANNOT BE FOUND ERROR &
: ### use updateable query
:
: cant i fix this problem once and for all.
:
: 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!?
: HotJobs - Search new jobs daily now
: http://hotjobs.yahoo.com/
:

hi ken,

I had set the permissions for winnt/temp folder when i
last updated project on to the server, but at present
iam updating the latest version of the project with
another physical folder in wwwroot.
i had already checked the permissions for winNT/Temp
permissions are OK.
what might be the problem.

ERROR : Page Cannot be displayed.
ERROR : Database or object is readonly ( i checked
properties of MDB file its fine)
ERROR : while Updating Database with ASP pages "use
updateable query"

what might be the problem ,
your early response will be highly appreciated.


Thanks

Syed
--- Ken Schaefer <ken@a...> wrote:
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: "syed moiz" <sa_moiz@y...>
> Subject: [access_asp] Re: file path problems
> 
> 
> : hi Ken,
> :
> : is it necessary to change the security permissions
> on
> : WINNT/TEMP
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 
> Yes. The Jet database engine using the Winnt\Temp
> directory to store it's
> temporary working files. The anonymous internet user
> account needs
> appropriate permissions to this temporary directory
> 
> Cheers
> Ken
> 
> 
> : whenever i update the fresh ASP Project Files.
> : Iam asking this because as u said to me last time
> i
> : tried with changing security permissions and
> Project
> : worked fine on local intranet server.
> : and now i have some major changes done to the
> project
> : and i had updated files on server but again
> : update,insert and select queries contained ASP
> Pages
> : are not displayed,
> :
> : ERRORS
> :
> : ### PAGE CANNOT BE FOUND ERROR &
> : ### use updateable query
> :
> : cant i fix this problem once and for all.
> :
> : 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!?
> : HotJobs - Search new jobs daily now
> : http://hotjobs.yahoo.com/
> :
> 
> 


__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/

hi ken,

I had set the permissions for winnt/temp folder when i
last updated project on to the server, but at present
iam updating the latest version of the project with
another physical folder in wwwroot.
i had already checked the permissions for winNT/Temp
permissions are OK.
what might be the problem.

ERROR : Page Cannot be displayed.
ERROR : Database or object is readonly ( i checked
properties of MDB file its fine)
ERROR : while Updating Database with ASP pages "use
updateable query"

what might be the problem ,
your early response will be highly appreciated.


Thanks

Syed

--- Ken Schaefer <ken@a...> wrote:
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: "syed moiz" <sa_moiz@y...>
> Subject: [access_asp] Re: file path problems
> 
> 
> : hi Ken,
> :
> : is it necessary to change the security permissions
> on
> : WINNT/TEMP
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 
> Yes. The Jet database engine using the Winnt\Temp
> directory to store it's
> temporary working files. The anonymous internet user
> account needs
> appropriate permissions to this temporary directory
> 
> Cheers
> Ken
> 
> 
> : whenever i update the fresh ASP Project Files.
> : Iam asking this because as u said to me last time
> i
> : tried with changing security permissions and
> Project
> : worked fine on local intranet server.
> : and now i have some major changes done to the
> project
> : and i had updated files on server but again
> : update,insert and select queries contained ASP
> Pages
> : are not displayed,
> :
> : ERRORS
> :
> : ### PAGE CANNOT BE FOUND ERROR &
> : ### use updateable query
> :
> : cant i fix this problem once and for all.
> :
> : 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!?
> : HotJobs - Search new jobs daily now
> : http://hotjobs.yahoo.com/
> :
> 
> 


__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2