Workspace / Transactions

[Paulo]

In order to use transactions (my macro upload data from Excel to Access), I
have to create a workspace variable, as described in the code below.

Dim wrkDefault As Workspace
Set wrkDefault = DBEngine.Workspaces(0)
wrkDefault.BeginTrans
....
wrkDefaut.CommitTrans

However, whenever I try to run the macro, I get the message: "Compile Error:
User-defined Type not defined". I used to think Workspace was not a
user-defined type. Does anyone know why it is happening?

Thanks in advance,

Paulo

 

[paul.robinson]

Hi
you must set a reference to the ADO object Library (Tools,
References...in the VBE) as you are not accessing an Excel object (so
Excel doesn't know what Workspace is and assumes it is a user defined
type).
regards
Paul

 

[Paulo]

Thanks, but could you please tell the exact name of the reference? I have
tried some, but they have not worked. Thanks in advance. Paulo

 

[paul.robinson]

Hi
I don't know DB stuff much, but try MicroSoft DAO object library
instead of AD0.