Workspace

[Joshann]

I am using Access 2000 and am trying to reference the group that the current user is in. I have seen examples in the knowledgebase that I think might work, but I can't even get the very first part to work. I start with:
Dim W as WorkSpace
and I get the following error message:
"User-defined type not defined"

Does anyone know why I'm getting this message and how to fix the problem?

Thanks!

 

[Travis]

What version of Access are you using?

Access 2000 defaults to using ADO.

While Earlier versions default to DAO.

In both cases make sure that you Reference the DAO DLL in your MDB Files References.

 

[Joshann]

I'm using Access 2000. I'm not very familiar with References. There are 4 Microsoft DAO References listed. Does it matter which one I use?

Thanks!

 

[Travis]

I prefer DAO 3.6 Object Library

 

[Joshann]

Thanks!