Skip site navigation (1) Skip section navigation (2)

Force commit in M$ Access?

From: "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Force commit in M$ Access?
Date: 2004-02-18 18:41:57
Message-ID: s033418d.060@groupwise.abag.ca.gov (view raw or flat)
Thread:
Lists: pgsql-odbc
Folks

Does anyone know if it is possible, when using an Access bound form
against a postgresql table, to force changes to commit?

When the user navigates to a new record Access updates the linked
postgres table, but due to a design flaw in the data structures, my life
would be easier if I could force the changed data to update before the
user navigates to a new record.

My initial solution was to issue an UPDATE query whenever the user
changed the offending data, but that results in the error
"You and another user have updated the same data, do you want
to:Discard changes, Copy to clipboard..." (something like that)
as soon as the user closes the form or moves to a new record.

(Yes, I know the correct answer is to fix the flaw, but the managers
here want to slay dragons with beebee guns and don't want to spend
money.)

Thanks in advance for your help!

Fred Parkinson
Grand Canyon Software
For
The Association of Bay Area Governments
510-464-7931

Responses

pgsql-odbc by date

Next:From: Matthew and Karen BrownDate: 2004-02-18 19:04:02
Subject: Re: Force commit in M$ Access?
Previous:From: Richard WeltyDate: 2004-02-18 01:38:37
Subject: Re: I want to use postresql for this app, but...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group