|
| |
|
|
nmathews
Posts: 50
Joined: 2/10/2002
From:
Status: offline
 |
" Operation must use an updateable query" - 10/23/2002 14:30:25
This query use to work on our old server. Now that we moved it to a new server and reestablished the database connections i get this error when i click update on my update pages. Any Ideas?
Database Results Error
Description: [Microsoft][ODBC dBase Driver] Operation must use an updateable query.
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Drivers
< Message edited by Spooky -- 1/11/2003 7:56:31 PM >
|
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: updateable query - 10/24/2002 6:03:57
Hi,
Doug G,
Congratulations for the new forum. I have just registered.
Hisham
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: updateable query - 10/24/2002 6:06:21
Hi,
Just a thought.
When you create a query in Access and that query depends on more than one table, or it returns group values like Distinct, sum ..etc it will not be an updateable query. You can' t even use it to add records in Access itself.
Best regards
Hisham
| |
|
|
|
nmathews
Posts: 50
Joined: 2/10/2002
From:
Status: offline
|
RE: updateable query - 11/6/2002 11:03:59
I contacted my provider and they tell me to use this:
SQL = " UPDATE Products Set UnitPrice = 2;"
Set Conn = Server.CreateObject(" ADODB.Connection" )
Conn.Mode = 3 ' 3 = adModeReadWrite
Conn.Open " myDSN"
Conn.Execute(SQL)
Conn.Close
Where is this code suppose to go? On the page or in the global.asa file. I haven' t been able to find any place where it fits in.
| |
|
|
|
nmathews
Posts: 50
Joined: 2/10/2002
From:
Status: offline
|
RE: updateable query - 11/6/2002 14:23:13
Yes that is correct. I' m trying to add/update/delete records from the database. It worked on old server without a problem, now that we moved the site it refuses to do so.
Here is the code
<%
fp_sQry=" SELECT * FROM CALENDAR ORDER BY EVENT_DATE ASC"
fp_sDefault=" "
fp_sNoRecords=" No records returned."
fp_sDataConn=" mainpagequery"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=" EVENT_NAME"
fp_sMenuValue=" EVENT_NAME"
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file=" _fpclass/fpdbrgn1.inc" -->
<!--webbot bot=" DatabaseRegionStart" endspan i-CheckSum=" 25530" -->
<form METHOD=" POST" action=" edit_cal2.asp" >
<!--webbot bot=" PurpleText"
PREVIEW=" Set this form' s properties so it submits user input to the appropriate page."
-->
<table BORDER=" 0" width=" 100%" >
<tr>
<td width=" 148" ><b>Event Name</b></td>
<td width=" 284" ><input TYPE=" TEXT" NAME=" EVENT_NAME" SIZE=" 40" VALUE=" <%=FP_FieldHTML(fp_rs," EVENT_NAME" )%>" ></td>
<td></td>
</tr>
<tr>
<td><b>Event Date</b></td>
<td><input TYPE=" TEXT" NAME=" EVENT_DATE" SIZE=" 40" VALUE=" <%=FP_FieldHTML(fp_rs," EVENT_DATE" )%>" ></td>
<td width=" 145" ></td>...........................................
| |
|
|
|
nmathews
Posts: 50
Joined: 2/10/2002
From:
Status: offline
|
RE: updateable query - 11/6/2002 16:45:21
I' m not sure I fully understand. I opened the site live with FrontPage and right clicked on the fpdb folder and looked and the check box is checked for running scripts. I went into the server via ftp and right clicked on the database file to see if everyone had permission to write to it, but the server does not allow that type of action.
| |
|
|
|
nmathews
Posts: 50
Joined: 2/10/2002
From:
Status: offline
|
RE: updateable query - 11/13/2002 11:43:51
I figured it out. I had the *.mdb database so it would upload to the server. It uploaded all my old dbf files but just not the *.mdb file.
Thanks for all your support!
| |
|
|
|
LynxEye
Posts: 1
Joined: 11/6/2004
Status: offline
|
RE: " Operation must use an updateable query" - 11/6/2004 9:48:48
I think i have the solution, at least it worked for me. I'm an XP Pro user having NTFS file system. Running ASP scripts that does insert/update query's on an Access DB.
- Go to your Control Panel
- Administrative Tools > IIS
- Expand the folder of your site/application
- Right-click the DB folder (just the folder where your .mdb is in)
- Go to "All-tasks" and click "Permissions Wizard"
- Click "Next" for 4 times, without changing anything and finish
You can probably do the same on a folder lower in the tree, but what the hell.. this worked..
< Message edited by LynxEye -- 11/6/2004 9:57:20 >
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 
