I am trying to delete records from a MS-Access DB table using the
following query:
strSQL=DELETE FROM MyTable WHERE
[id]=CInt(Request.Q ueryString("del ete"))
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_MachineNam e has for this "db" directory (through the web
browser - the hosting service has given this option), then I find that
IUSR_MachineNam e has only the Read permission but when I try to set
this directory's Write & Modify permissions for IUSR_MachineNam e, then
I am not being allowed to do so. So could this be the cause of the
error?
3  10283  rn**@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.Q ueryString("del ete"))
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_MachineNam e has for this "db" directory (through the web
browser - the hosting service has given this option), then I find that
IUSR_MachineNam e has only the Read permission but when I try to set
this directory's Write & Modify permissions for IUSR_MachineNam e, 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"
--
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
<rn**@rediffmai l.comwrote in message
news:11******** **************@ g37g2000prf.goo glegroups.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.Q ueryString("del ete"))
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_MachineNam e has for this "db" directory (through the web
browser - the hosting service has given this option), then I find that
IUSR_MachineNam e has only the Read permission but when I try to set
this directory's Write & Modify permissions for IUSR_MachineNam e, 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
"John Blessing" <blessij@**REMO VE**THIS**gmail .comwrote in message
news:9d******** **********@news fe1-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
<rn**@rediffmai l.comwrote in message
news:11******** **************@ g37g2000prf.goo glegroups.com.. .
>>I am trying to delete records from a MS-Access DB table using the
following query:
strSQL=DELET E FROM MyTable WHERE
[id]=CInt(Request.Q ueryString("del ete"))
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
unfortunatel y 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_MachineNam e has for this "db" directory (through the web
browser - the hosting service has given this option), then I find that
IUSR_MachineNa me has only the Read permission but when I try to set
this directory's Write & Modify permissions for IUSR_MachineNam e, 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 <gAnd I also meant .mdb (not .mb)
--
John Blessing This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Gb |
last post by:
Hi There,
I have:
select myTable.*,
Case
When myTable.problem_CLOSE_date = myTable.problem_creation_date then
2
When myTable.problem_CLOSE_date >0 and myTable.problem_status='C'
then 3
When myTable.problem_CLOSE_date >0 and myTable.problem_status='R'
|
by: stimsonm2000 |
last post by:
I am having a hard time inserting data into a ms access db that has two
tables joined together.
the first table called tblMainCategories has two fields (MainCategoryID
and MainCat_Name)
the second table called tblSubCategories has 4 fields (SubCategoryID,
SubCat_MainCatID, SubCat_Name and year)
these tables are linked by the SubCat_MainCatID.
|
by: alan_conoco |
last post by:
Hi all,
I am trying to delete a subset of records (identified using my
InsertRemovePairs query) from a table names TradesDone.
When I execute the nested SELECT on its own it returns the correct
records. When I execute is nested in the DELETE it tries to delete
everything in my database....
What have I missed??
|
by: Chea Vichet |
last post by:
help me!
Could not delete from specified tables. with the follwing code
why?
thanks
protected void Button1_Click(object sender, EventArgs e)
{
|
by: MRounds |
last post by:
Hi
Have looked through many forums but cannot find a solution for this.
I have a table where i store certain dates and i want to use this table in several queries to delete records from multiple tables by using a macro to run the queries.
I can use DISTINCTROW to delete rows that are equal to a date but cannot figure out how to delete rows that are between a range of dates (stored in .
Example of my query :
DELETE...
| | |
by: jigu |
last post by:
hi all
When i try to delete records i receieve this error Could not delete from specified tables.
please help soon.
my code is here
<%
dim rs,myconnection
dim sql, mysql
set myconnection=server.CreateObject("ADODB.Connection")
myconnection.provider = "Microsoft.Jet.OLEDB.4.0"
Set rs=server.CreateObject("ADODB.Recordset")
|
by: Betty Boop |
last post by:
I am trying to import tables using an odbc connection on a periodic basis. I don't want to create a second copy of the tables, so I have to delete them all before doing the import. I found another question similar to this and tried the following code, but it doesn't work.
Private Sub btnPBGUpdate_Click()
Dim TblName As String
Dim obj As AccessObject, dbs As Object
Set dbs = Application.CurrentData
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
