New to the forum, so thanks for having me.
I'm submitting a form, and attempting to save it to a local copy of an ACCESS 2007 database. When I am submitting the form, I get the following error:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/JustBorn/form_submit.asp , line 414
Line 414 is: rs.Open "customer",myco nn,adOpenStatic ,adLockOptimist ic
been pouring over this for a while now, and finally breaking down and asking. The DB and form_submit.asp are in the same directory on an IIS server, held locally, but will be posted eventually. Any and all help would be appreciated.
Anthony
Beginner Programmer -
<%
-
-
DIM repID, cusName, cusPhone, cusAddress, cusCity, cusState, cusZip, product, upccode, mfgcode, bestByDate, purchased, store, notes, contacted, spokewith
-
-
repID = request.form("repID")
-
cusPhone = request.form("cusPhone")
-
cusAddress = request.form("cusAddress")
-
cusCity = request.form("cusCity")
-
cusState = request.form("cusState")
-
cusZip = request.form("cusZip")
-
product = request.form("product")
-
upccode = request.form("upccode")
-
mfgcode = request.form("mfgcode")
-
bestByDate = request.form("bestByDate")
-
purchased = request.form("purchased")
-
store = request.form("store")
-
notes = request.form("notes")
-
contacted = request.form("contacted")
-
spokewith = request.form("spokewith")
-
-
DIM myconn, RS, curDate, dbPath, dbName
-
curDate = Date
-
dbName = "JustBorn.accdb"
-
dbPath = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath(dbName) & ";Persist Security Info=False;"
-
-
-
Set myconn = CreateObject("ADODB.Connection")
-
Set rs = CreateObject("ADODB.Recordset")
-
myconn.Open = dbPath
-
-
rs.Open "customer",myconn,adOpenStatic,adLockOptimistic
-
-
rs.AddNew
-
-
rs("CurDate") = curDate
-
rs("RepID") = repID
-
rs("CusName") = cusName
-
rs("CusPhone") = cusPhone
-
rs("CusAddress") = cusAddress
-
rs("CusCity") = cusCity
-
rs("CusState") = cusState
-
rs("CusZip") = cusZip
-
rs("Product") = product
-
rs("UPCCode") = upccode
-
rs("MFGCode") = mfgcode
-
rs("BestByDate") = bestByDate
-
rs("Purchased") = purchased
-
rs("Store") = store
-
rs("Notes") = notes
-
rs("Contacted") = contacted
-
rs("spokewith") = spokewith
-
-
rs.Update
-
-
'grab the ID value
-
DIM ID
-
ID = RS(0)
-
-
%>
-
-
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
-
-
<html>
-
<head>
-
<title>Just Born</title>
-
</head>
-
-
<body>
-
-
<p align="center">
-
<table align="center" cellpadding="5" border="3" bordercolordark="#707070" bordercolorlight="#E0E3DC">
-
<tr>
-
<td align="center" valign="middle">
-
SAVE CONFIRMED
-
</td>
-
<tr>
-
<td align="center" valign="middle" bgcolor="#E6EFF7">
-
<p style="font-family:sans-serif;">
-
Record <%=ID%> Saved<br>
-
<input type="Button" value="CONTINUE" onClick="window.location='<%=ReturnTo%>'">
-
</p>
-
</td>
-
</tr>
-
</table>
-
-
<!--#include file="footer.asp"-->
-
</p>
-
-
</body>
-
</html>
-
-
<%
-
'cleanup
-
rs.Close
-
set rs=nothing
-
myconn.close
-
set myconn=nothing
-
%>
3 4795 jhardman 3,406
Recognized Expert Specialist
Try adOpenDynamic rather than adOpenStatic. According to the documentation (as far as I can tell) either should work, but the last time I got this error, I changed cursor type and it worked. Let me know if this helps.
JAred
I've tried all of them (except the readony one), and still the same error message
jhardman 3,406
Recognized Expert Specialist
then the issue might be that you don't have permission. I notice you are not passing login credentials. What kind of db are you using? most have a connection string you can use to pass login info.
Jared
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: mgm |
last post by:
hello,
I have a query that is supposed to return only 1 record, however I recently
found that because of an error in the database it can return more than 1.
So what I need to do is capture if it is more than 1 record and alert the
user to contact the database administrator. How can I get the count of
records returned by a recordset? Is there no way besides looping through
with a counter variable?
|
by: Ryan |
last post by:
Access97
I hope someone out there can help. This is driving me crazy.
Basically, I am trying to recreate VBA's built in navigation feature
(The one that allows you to move first, next, previous, and last and
also tells you that you are on Record # or . The
navigation part was easy. My problem is determing the what record I
am on and the total number of records.
I put the following code into the my subforms on Current event:
|
by: Zlatko Matiæ |
last post by:
There is a form (single form) and a combobox. I want that current record of
the form is adjusted according to selected value in the combobox. Cuurrent
record should be the same as the value in the combobox.
What is the solution?
Thank you in advance.
|
by: barret bonden |
last post by:
(closest newsgroup I could find)
Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the
provider, or of the selected locktype.
/asp_data3_add.asp, line 30
<%
'Dimension variables
Dim adoCon 'Holds the Database Connection Object
|
by: Hexman |
last post by:
I've come up with an error which the solution eludes me. I get the
error:
>An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in HRTest.exe
>
>Additional information: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
It occurs when I attempt to add a new record. I've stripped out much
of the code, leaving the pertinent (I hope) info. ...
| |
by: Johnfli |
last post by:
ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of
the provider or of the selected cursortype.
I am moving my webserver from NT4 using SQL to win2003 using SQL 2003
I get the above error when my asp page does teh line:
Rs.absolutepage = intCurrentPage
I tested teh value of intCurrent page and teh value is 1.
|
by: melnhed |
last post by:
---Report the current filtered records from a Form---
Hello All,
I've seen this topic discussed before, but the solution described then
doesn't work in my particular case.
My Config: Access 2002 front-end using SQL Server 2000 (MSDE actually)
via ADP/ADE Access Data Project.
|
by: jamesnkk |
last post by:
I got this Run-time error 3251
Current Recrdset does not support updating. This may be limation of the provider, or of the selected locktype.
Dim red1 As New ADODB.Recordset
Dim strmess As String
Set cnp = CurrentProject.Connection
strmess = "SELECT * from tblinvoicelines WHERE invoice=" & newInvo
|
by: michal |
last post by:
hi guys,
i am using postgres 8.2 and try to add some records to a table with
ADODO ... unfortunately i end up with an error when calling the
addNew() method. it says that the recordset does not support
updating...
i do open the connection the following
set RS = server.createObject("scripting.dictionary")
RS.open "usr", cn, 1, 3, 2
|
by: BlackMustard |
last post by:
Hi,
I get the following error on the last line:
Run-time error '3251':
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
' Open database connection
Set adoConn = CreateObject("ADODB.Connection")
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |