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