Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Online Data entry using Access and ASP


Message #1 by adeel@j... on Sun, 5 Aug 2001 01:10:28
I want to achieve online data entry using ASP and Microsoft Access. The 

data entered by the user fails to be saved in the wwwroot folder of my IIS 

webserver. The problem is that I have only this folder as I have paid for 

webhosting services and cannot run my physical webserver. The error 

whenever I try to achieve this is "Operation must use an Updatable Query." 



Kindly Help me. 



Adeel Aslam

Web and Software Developer
Message #2 by "Ethan Selzer" <ethanselzer@m...> on Sun, 5 Aug 2001 06:55:53 -0700
Hi Adeel,



This error usually occurs when write permissions are not set. Ask your host

to adjust the folder where your .mdb file is located to read/write

permissions.



Ethan



-----Original Message-----

From: adeel@j... [mailto:adeel@j...]

Sent: Sunday, August 05, 2001 1:10 AM

To: Access ASP

Subject: [access_asp] Online Data entry using Access and ASP



I want to achieve online data entry using ASP and Microsoft Access. The

data entered by the user fails to be saved in the wwwroot folder of my IIS

webserver. The problem is that I have only this folder as I have paid for

webhosting services and cannot run my physical webserver. The error

whenever I try to achieve this is "Operation must use an Updatable Query."



Kindly Help me.



Adeel Aslam

Web and Software Developer






Message #3 by adeel@j... on Tue, 7 Aug 2001 03:01:27
Respected Ethan



Thank you for your reply. I am using IIS 5.0 locally and at my home I 

cannot submit data entry in the wwwroot folder I have tried all the 

techniques/settings I know and failed. I can enter all the data in webpub 

folder locally. No host provides two folders I get wwwroot only Please 

guide me through to set permissions and settings to have databases in 

wwwroot updated. 



Adeel Aslam 







> Hi Adeel,

> 

> This error usually occurs when write permissions are not set. Ask your 

host

> to adjust the folder where your .mdb file is located to read/write

> permissions.

> 

> Ethan

> 

> -----Original Message-----

> From: adeel@j... [mailto:adeel@j...]

> Sent: Sunday, August 05, 2001 1:10 AM

> To: Access ASP

> Subject: [access_asp] Online Data entry using Access and ASP

> 

> I want to achieve online data entry using ASP and Microsoft Access. The

> data entered by the user fails to be saved in the wwwroot folder of my 

IIS

> webserver. The problem is that I have only this folder as I have paid for

> webhosting services and cannot run my physical webserver. The error

> whenever I try to achieve this is "Operation must use an Updatable 

Query."

> 

> Kindly Help me.

> 

> Adeel Aslam

> Web and Software Developer



Message #4 by John Jensen <John@k...> on Tue, 7 Aug 2001 13:47:46 -0700
I too have run across your problem MANY times on sites that I have created

for others and support.  I would agree with Ethan.  What you need to do is

use a product like ws_ftp or frontpage that will allow you to create

additional sub-folders within your wwwroot.  From that folder, you will need

your ISP to set the new folder public permissions to read/write.  The

problem is, by default (security reasons) all web folders are set to public

read only. When the web form tries to write to the database, it cannot, as

the database cannot re-write itself.  Hope this helps...

John

Dba www.kiss.com





-----Original Message-----

From: adeel@j... [mailto:adeel@j...]

Sent: Monday, August 06, 2001 8:01 PM

To: Access ASP

Subject: [access_asp] Re: Online Data entry using Access and ASP



Respected Ethan



Thank you for your reply. I am using IIS 5.0 locally and at my home I

cannot submit data entry in the wwwroot folder I have tried all the

techniques/settings I know and failed. I can enter all the data in webpub

folder locally. No host provides two folders I get wwwroot only Please

guide me through to set permissions and settings to have databases in

wwwroot updated.



Adeel Aslam







> Hi Adeel,

>

> This error usually occurs when write permissions are not set. Ask your

host

> to adjust the folder where your .mdb file is located to read/write

> permissions.

>

> Ethan

>

> -----Original Message-----

> From: adeel@j... [mailto:adeel@j...]

> Sent: Sunday, August 05, 2001 1:10 AM

> To: Access ASP

> Subject: [access_asp] Online Data entry using Access and ASP

>

> I want to achieve online data entry using ASP and Microsoft Access. The

> data entered by the user fails to be saved in the wwwroot folder of my

IIS

> webserver. The problem is that I have only this folder as I have paid for

> webhosting services and cannot run my physical webserver. The error

> whenever I try to achieve this is "Operation must use an Updatable

Query."

>

> Kindly Help me.

>

> Adeel Aslam

> Web and Software Developer




  Return to Index