I have a postgresql backend with an access front end and I am trying to
redefine the recordset of the form to use an ADO recordset. The problem is
that the CursorType always changes to AdOpenStatic, even if I choose
adOpenDynamic. If anyone has any thoughts, please let me know. The form
works great for viewing, but I cannot update or insert any new records.
Below is the code I am using:
connectstr = "DSN=SAP_PG;uid =postgres"
Set conn = New ADODB.Connectio n
conn.Open (connectstr)
rs.CursorLocati on = adUseClient
rs.Open "select ProductID,Produ ctName,ProductT ypeID,StockType ID from
Products order by ProductName", conn, adOpenDynamic, adLockOptimisti c
Set Me.Recordset = rs
Me.Requery
The conn object contains the following:
Provider=MSDASQ L.1;Extended
Properties="DSN =SAP_PG;DATABAS E=sap;SERVER=10 .1.1.76;PORT=54 32;UID=username ;
PWD=password;Re adOnly=0;Protoc ol=6.4;FakeOidI ndex=0;ShowOidC olumn=0;RowVers i
oning=1;ShowSys temTables=0;Con nSettings=;Fetc h=100;Socket=40 96;UnknownSizes =
0;MaxVarcharSiz e=4094;MaxLongV archarSize=4094 ;Debug=0;CommLo g=0;Optimizer=1 ;
Ksqo=1;UseDecla reFetch=0;TextA sLongVarchar=0; UnknownsAsLongV archar=0;BoolsA s
Char=0;Parse=0; CancelAsFreeStm t=0;ExtraSysTab lePrefixes=dd_; ;LFConversion=1 ;
UpdatableCursor s=1;DisallowPre mature=0;TrueIs Minus1=0;BI=0;B yteaAsLongVarBi n
ary=0;UseServer SidePrepare=0"
In answer to your upcoming questions:
1) ProductID is the primary key on the table.
2) I do not want to use linked forms, they go much slower then connecting
directly through the ADO recordset.
3) I put a breakpoint right after the open statement and checked the value
of rs.CursorType and that is when I saw it was adOpenStatic
4) I am using PostGreSQL 8.0beta1
5) ODBC driver 7.03.02.00
3  5486 
On Tue, Nov 09, 2004 at 01:53:18PM +0200, Sim Zacks wrote: I have a postgresql backend with an access front end and I am trying to
redefine the recordset of the form to use an ADO recordset. The problem is
that the CursorType always changes to AdOpenStatic, even if I choose
adOpenDynamic. If anyone has any thoughts, please let me know. The form
works great for viewing, but I cannot update or insert any new records.
Postgres does not support updatable cursors yet. Maybe that's why the ADO
driver changes the cursor type from AdOpenDynamic to AdOpenStatic.
--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Nunca se desea ardientemente lo que solo se desea por razón" (F. Alexandre)
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org
hat pretty much solves my problem. Also I found that Access doesn'r support
ODBC updateable cursors until at least Access 2002 (we're using Access
2000), though I thought I had figured out how to get around that and it
didn't work.
I assumed the ODBC driver did support updateable cursors simply because
there is an option in the driver settings called "Updateable cursor"
Thank you for your clarification.
Sim Zacks
IT Manager
Compulab
to email me use: sim "the at sign" compulab "the dot" co "the dot" il
"Alvaro Herrera" <al******@dcc.u chile.cl> wrote in message
news:20******** ************@dc c.uchile.cl... On Tue, Nov 09, 2004 at 01:53:18PM +0200, Sim Zacks wrote: I have a postgresql backend with an access front end and I am trying to
redefine the recordset of the form to use an ADO recordset. The problem
is that the CursorType always changes to AdOpenStatic, even if I choose
adOpenDynamic. If anyone has any thoughts, please let me know. The form
works great for viewing, but I cannot update or insert any new records.
Postgres does not support updatable cursors yet. Maybe that's why the ADO
driver changes the cursor type from AdOpenDynamic to AdOpenStatic.
--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Nunca se desea ardientemente lo que solo se desea por razón" (F.
Alexandre)
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On second thought, I am now confused. The data is updatable when using
linked tables, just not when using ADO recordsets connected to forms. I
tried connected to PostGreSQL using DAO, and I got the recordset back, but
it was also non-updatable.
For the time being I am using Linked Tables, even though it is much slower
to open the forms using that methodology.
--
Sim Zacks
IT Manager
Compulab
to email me it is sim "the at sign" compulab "the dot" co "the dot" il
"Sim Zacks" <si*@nospam.com > wrote in message
news:cn******** ***@news.hub.or g... hat pretty much solves my problem. Also I found that Access doesn'r
support ODBC updateable cursors until at least Access 2002 (we're using Access
2000), though I thought I had figured out how to get around that and it
didn't work.
I assumed the ODBC driver did support updateable cursors simply because
there is an option in the driver settings called "Updateable cursor"
Thank you for your clarification.
Sim Zacks
IT Manager
Compulab
to email me use: sim "the at sign" compulab "the dot" co "the dot" il
"Alvaro Herrera" <al******@dcc.u chile.cl> wrote in message
news:20******** ************@dc c.uchile.cl... On Tue, Nov 09, 2004 at 01:53:18PM +0200, Sim Zacks wrote: I have a postgresql backend with an access front end and I am trying
to redefine the recordset of the form to use an ADO recordset. The
problem is that the CursorType always changes to AdOpenStatic, even if I choose
adOpenDynamic. If anyone has any thoughts, please let me know. The
form works great for viewing, but I cannot update or insert any new
records.
Postgres does not support updatable cursors yet. Maybe that's why the
ADO driver changes the cursor type from AdOpenDynamic to AdOpenStatic.
--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Nunca se desea ardientemente lo que solo se desea por razón" (F.
Alexandre)
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Henry Bloom |
last post by:
Hello,
I have two questions:
1. The file-size of my mdb-Database grew extremely large after having
written a lot of VBA-code. I know about the /decompile-option tried it
.... it did not work. Why? what to do now?
2. I have a query producing an updatable dynaset of data. When I tried
opening it in a VBA-routine like
|
by: Steve Jorgensen |
last post by:
Hi all,
Over the years, I have had to keep dealing with the same Access restriction -
that you can't update a table in a statement that joins it to another
non-updateable query or employs a non-updateable subquery. I run across this
problem again and again, and yet I've never come up with a single, universal
work-around.
I'm wondering what other people here are doing.
|
by: Just_Buy |
last post by:
Environment: MS Access 97
Problem:
Trying to force a record to update using the recordset.Update
property. What syntax do I need to force a record to be updated? I
have searched the newsgroups and web and haven't found a solution that
works.
Thanks!
|
by: Bob Darlington |
last post by:
I am using code (simplified for this post) to generate a recordset to which
I want to add a record.
Set rs = db.Openrecordset("SELECT * FROM qVariations WHERE ......")
ws.Begintrans
If rs.Updatable then
rs.AddNew
rs!LAN = vLAN
rs.Update
etc
|
by: kentsoi |
last post by:
i write the code as follow:
when i try to edit text3's content'
the message " this recordset is not updatable" is display.
can anyone tell me what's wrong ???
thanks a lot
*******************************
| | |
by: David C. Barber |
last post by:
I've upsized an Access 2000 MDB to an ADP and changed the tables from a
linked Access Backend to SQL Server. Now I'm told I can't use DAO any more
and need to convert to ADO. While I've used ADO in VB6, there I created my
connection object and had easy access to it. All I want to know is how do I
convert:
Dim db as DAO.Database
Dim rs as DAO.Recordset
Set db = currentdb
|
by: magickarle |
last post by:
Hi to all.
Little introduction on what I'm trying to do:
I'm in charge of creating an access database for our supervisor where
they can grade their agents.
Per ex: agents are talking to customers and the supervisor is
listening to their conversation (and grading them as per a specific
template)
What I've done so far:
Created Tables for the entry of:
|
by: beceri |
last post by:
Hi ;
I use too mix query ( four relationship and main and child tables :) )
so that of couse my query is not updatable I agree this ! :(
but I want to different thing ; when form is open my mix query is run and take me all data but when I want to change some textbox (recordset dont allow me changing table data )I want to change textbox (not table data) after that I change textbox data with specially recordset in focus sub
how can...
|
by: shajimon |
last post by:
hai All
I am very new to PostgreSql.
I have given the following code to VB 6. and it takes around 2 to 3 minutes to exicute with PostgreSQL back end. However, the same code work in a fraction of a second with MS Access back end . Kindly advise me on how to improve its perfomance with PostgrSQL 8.4.2
Option Explicit
Dim dbill As New ADODB.Connection
Dim mtlmast As New ADODB.Recordset
Dim rs As New ADODB.Recordset
Dim rss As New...
|
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
