Could not delete from specified tables.

I am trying to delete records from a MS-Access DB table using the
following query:

strSQL=DELETE FROM MyTable WHERE
[id]=CInt(Request.QueryString("delete"))
con.Execute strSQL

When I run the app on my local IIS 5.1 server (on WinXP SP2), records
get deleted without any problems but when I upload the same file
(which has the above DELETE query) to the actual remote server, then
ASP generates the following error:

Could not delete from specified tables.

I have gone through numerous posts & articles to resolve the issue but
unfortunately the error still persists. The only apprehension that
comes to my mind is could permissions to the directory which houses
the MS-Access DB table be the cause of this error.

Actually in the remote server, the Access DB table resides in a
directory named "db" (without the quotes). When I view the permissions
that IUSR_MachineName has for this "db" directory (through the web
browser - the hosting service has given this option), then I find that
IUSR_MachineName has only the Read permission but when I try to set
this directory's Write & Modify permissions for IUSR_MachineName, then
I am not being allowed to do so. So could this be the cause of the
error?

Re: Could not delete from specified tables.

rn5a@rediffmail.com wrote:
> I am trying to delete records from a MS-Access DB table using the
> following query:
>
> strSQL=DELETE FROM MyTable WHERE

Depending on the version of Access you are using, you may need to use the

Delete * from MyTable ...

syntax.

> [id]=CInt(Request.QueryString("delete"))
> con.Execute strSQL
>
> When I run the app on my local IIS 5.1 server (on WinXP SP2), records
> get deleted without any problems but when I upload the same file
> (which has the above DELETE query) to the actual remote server, then
> ASP generates the following error:
>
> Could not delete from specified tables.
>
> I have gone through numerous posts & articles to resolve the issue but
> unfortunately the error still persists. The only apprehension that
> comes to my mind is could permissions to the directory which houses
> the MS-Access DB table be the cause of this error.
>
> Actually in the remote server, the Access DB table resides in a
> directory named "db" (without the quotes). When I view the permissions
> that IUSR_MachineName has for this "db" directory (through the web
> browser - the hosting service has given this option), then I find that
> IUSR_MachineName has only the Read permission but when I try to set
> this directory's Write & Modify permissions for IUSR_MachineName, then
> I am not being allowed to do so.

Describe what is preventing you from doing so. Do you have "Simple File
Sharing" turned off?

> So could this be the cause of the
> error?

Maybe. Can you use INSERT or UPDATE against that database? If not, then you
do have a Permissions problem.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Could not delete from specified tables.

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters

wrote in message
news:1181212570.734556.166430@g37g2000prf.googlegroups.com.. .
>I am trying to delete records from a MS-Access DB table using the
> following query:
>
> strSQL=DELETE FROM MyTable WHERE
> [id]=CInt(Request.QueryString("delete"))
> con.Execute strSQL
>
> When I run the app on my local IIS 5.1 server (on WinXP SP2), records
> get deleted without any problems but when I upload the same file
> (which has the above DELETE query) to the actual remote server, then
> ASP generates the following error:
>
> Could not delete from specified tables.
>
> I have gone through numerous posts & articles to resolve the issue but
> unfortunately the error still persists. The only apprehension that
> comes to my mind is could permissions to the directory which houses
> the MS-Access DB table be the cause of this error.
>
> Actually in the remote server, the Access DB table resides in a
> directory named "db" (without the quotes). When I view the permissions
> that IUSR_MachineName has for this "db" directory (through the web
> browser - the hosting service has given this option), then I find that
> IUSR_MachineName has only the Read permission but when I try to set
> this directory's Write & Modify permissions for IUSR_MachineName, then
> I am not being allowed to do so. So could this be the cause of the
> error?

Yes.

You need read, write, create, delete permissions in the folder containing
the .mb

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters

Re: Could not delete from specified tables.

"John Blessing" wrote in message
news:9dT9i.22892$xU4.3409@newsfe1-gui.ntli.net...
>
>
> --
> John Blessing
>
> http://www.LbeHelpdesk.com - Help Desk software priced to suit all
> businesses
> http://www.room-booking-software.com - Schedule rooms & equipment bookings
> for your meeting/class over the web.
> http://www.lbetoolbox.com - Remove Duplicates from MS Outlook,
> find/replace, send newsletters
>
> wrote in message
> news:1181212570.734556.166430@g37g2000prf.googlegroups.com.. .
>>I am trying to delete records from a MS-Access DB table using the
>> following query:
>>
>> strSQL=DELETE FROM MyTable WHERE
>> [id]=CInt(Request.QueryString("delete"))
>> con.Execute strSQL
>>
>> When I run the app on my local IIS 5.1 server (on WinXP SP2), records
>> get deleted without any problems but when I upload the same file
>> (which has the above DELETE query) to the actual remote server, then
>> ASP generates the following error:
>>
>> Could not delete from specified tables.
>>
>> I have gone through numerous posts & articles to resolve the issue but
>> unfortunately the error still persists. The only apprehension that
>> comes to my mind is could permissions to the directory which houses
>> the MS-Access DB table be the cause of this error.
>>
>> Actually in the remote server, the Access DB table resides in a
>> directory named "db" (without the quotes). When I view the permissions
>> that IUSR_MachineName has for this "db" directory (through the web
>> browser - the hosting service has given this option), then I find that
>> IUSR_MachineName has only the Read permission but when I try to set
>> this directory's Write & Modify permissions for IUSR_MachineName, then
>> I am not being allowed to do so. So could this be the cause of the
>> error?
>
> Yes.
>
> You need read, write, create, delete permissions in the folder containing
> the .mb
>
> --


Sorry for the top and bottom post And I also meant .mdb (not .mb)
--
John Blessing