DBEngine.BeginTrans problem

On Fri, 23 Mar 2007 10:18:41 -0700, "SAL" wrote:

¤ Hello all,
¤ is there an reason that the statement
¤ DBEngine.BeginTrans would cause an ActiveX component can't create object
¤ error? I've never seen this before and am a little stumped.
¤ If I remove the begin and end trans lines of code, the code execute as
¤ expected.

I would start your transaction on the Workspace instead of the database engine, or omit DBEngine
completely because it isn't necessary.


Paul
~~~~
Microsoft MVP (Visual Basic)
 >> Stay informed about: DBEngine.BeginTrans problem 

Why not show all the code dealing with DAO otherwise, its hard to help you
resolve it.


"SAL" wrote in message

> Hello all,
> is there an reason that the statement
> DBEngine.BeginTrans would cause an ActiveX component can't create object
> error? I've never seen this before and am a little stumped.
> If I remove the begin and end trans lines of code, the code execute as
> expected.
>
>
> S
>
 >> Stay informed about: DBEngine.BeginTrans problem