t; Check permissions for updates/write for the user you are connecting.
>
> - Goutam
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Sim Zacks
> > Sent: Tuesday, November 09, 2004 6:53 AM
> > To: [
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 bec
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 tho
[EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Sim Zacks
> Sent: Tuesday, November 09, 2004 6:53 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] PostGreSQL to Access Updatable recordset
>
>
> I have a postgresql backend with an access front end and I am
> trying
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. I
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
