Transactions, PostgreSQL and MS Access front end.

From: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Transactions, PostgreSQL and MS Access front end.
Date: 2006-04-24 02:19:25
Message-ID: 1145845164.997186.103640@e56g2000cwe.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-04-24 02:32:17 Re: Transactions, PostgreSQL and MS Access front end.
Previous Message David F. Johnson 2006-04-24 01:33:40 "save history" problem