|
 |
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
|
|
 |