Drop the semicolon at the end of the string. In this context, it's not needed to tell where the end of the statement is. You might want to use a parameterized stored procedure that does multiple updates inside a transaction. You would invoke the stored procedure via mdb.Execute, as per your example. --Wes Neal Lindsay <[EMAIL PROTECTED]> on 07/15/2001 06:31:24 PM To: [EMAIL PROTECTED] cc: (bcc: Wesley Sheldahl/Lex/Lexmark) Subject: [GENERAL] Using PostgreSQL transactions through MS Access? I am trying to update my database with a big transaction so I don't get an invalid state. My front end is in Access 97. Is there anyone out there who does this that could tell me what I'm doing wrong? Here's my code: queryString = "BEGIN TRANSACTION;" mdb.Execute queryString, dbSQLPassThrough It tells me that it's an "Invalid SQL Statement". It seems like Access is trying to parse it instead of sending it on to the DB server. I thought that the dbSQLPassThrough was supposed to stop that. Does anyone know where I went wrong? ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster