Обсуждение: Force commit in M$ Access?

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

On 18 Feb 2004 at 10:41, Fred Parkinson wrote:
> Does anyone know if it is possible, when using an Access bound form
> against a postgresql table, to force changes to commit?

This is probably a bad idea but
SendKeys "+{ENTER}"
might just work.

Pressing Shift+Enter in a form is supposed to commit changes to the
current record. I'm not sure if there is a cleaner VBA hook into that
functionality.

Aaron Spike

Hello,

You can use this routine:

---------------------------
Sub cmdSaveFct()
On Error GoTo cmdSaveFctError

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

cmdSaveFctExit:
    Exit Sub

cmdSaveFctError:
    MsgBox Err.description
    Resume cmdSaveFctExit
End Sub
---------------------------

Philippe Lang


-----Message d'origine-----
De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] De la part de Aaron Spike
Envoyé : mercredi, 18. février 2004 20:39
À : Fred Parkinson; pgsql-odbc@postgresql.org
Objet : Re: [ODBC] Force commit in M$ Access?

On 18 Feb 2004 at 10:41, Fred Parkinson wrote:
> Does anyone know if it is possible, when using an Access bound form
> against a postgresql table, to force changes to commit?

This is probably a bad idea but
SendKeys "+{ENTER}"
might just work.

Pressing Shift+Enter in a form is supposed to commit changes to the current record. I'm not sure if there is a cleaner
VBAhook into that functionality. 

Aaron Spike


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Hi Fred,

You might try the following code in whatever handler you wish (button
click, etc):

        DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
acMenuVer70

This will save the current record.

-- Matt Brown

Fred Parkinson wrote:

>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
>