I have a connection object (objConn) that is passed from a bas module to a
class within a project after BeginTrans.  In the receiving class, the
command

        objConn.Execute strSQL

fails, with the error message "Cannot create new connection because in
manual transaction mode", even though I'm not trying to create a new
connection.  strSQL is a simple select statement string that's verified to
be good.

Any idea what I might be doing wrong?  Thanks in advance.

Phil Galey

Phillip,
Use a server-side or client-side cursor other than the forward-only and read-only cursor.
http://support.microsoft.com/support/kb/articles/Q272/3/58.ASP

--

Thanks,
Carl Prothman
Microsoft Visual Basic MVP
http://www.able-consulting.com