Re: Transactions, PostgreSQL and MS Access front end.

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Karen Hill <karen_hill22(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Transactions, PostgreSQL and MS Access front end.
Date: 2006-04-24 02:32:17
Message-ID: 200604240232.k3O2WHh10976@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Karen Hill wrote:
> >From Access I'd like to run pass the following from MS Access to
> PostgreSQL 8.1 using VBA:
>
> BEGIN;
> UPDATE accounts SET balance = balance + 100.00 WHERE acctnum = 12345;
> UPDATE accounts SET balance = balance - 100.00 WHERE acctnum = 7534;
> COMMIT;
>
> It won't let me. Any ideas solutions?

What error does it show?

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karen Hill 2006-04-24 03:24:13 Re: Transactions, PostgreSQL and MS Access front end.
Previous Message Karen Hill 2006-04-24 02:19:25 Transactions, PostgreSQL and MS Access front end.