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? it should work in pass-through query, and the query could be generated by code (AFAIK, it has been a while i did Access). vlad
