Visual Basic Connection Command

I'm trying to set up a DataEnvironment connection with commands to build
recordsets.

In some situations, I get through ok, but in many cases, I get E_FAIL
messages.

Most notably, it looks like the UserNDS table is mostly inaccessible this
way.

Is there an explanation as to why I can't get some fields?
EMail Address_Addr from UserNDS is an example.

Is it just spaces in the column name? How do I get around this?
Is it simply that

Hi,

If your problem is spaces in names you can quote them in VB like this:

strSQL = "select CN, ""Password Allow Change"" from
UserNDS"
Set rs = cn.OpenRecordset(strSQL, dbOpenDynamic)

If your problem is with all fields after 255 (and there are a lot of them in
trees with zenworks or other aux classes, as all aux class attributes are
potential attributes for any objects in odbcnds), then you can use
odbcdirect or even better, create a user defined table including just those
attributes you will want, then base the query on the table instead, for
example

strSQL = "select CN, ""Password Allow Change"" from
_myTable"

I hope this helps.

Thank you
Susan