VBA Users & Groups

[chris watkins]

I'm trying to change an existing DB over to ADO instead of
DAO ....
There are several forms and controls that are currently
restricted to differing user groups through VBA (DAO) code.
I can't seem to get the ado code right to access who the
user is and which group they belong too.
I've searched & searched for references to this but have
had no luck!

hope someone can help.

cheers
chris

 

[Douglas J. Steele]

I don't believe it's possible.

ADO is a generic data access method, and so doesn't always work with
features specific to one DBMS.

Is there a reason why you're converting? If all you're using is a Jet
database (.MDB) to store your data, there's no need to. DAO is preferable in
that situation, as it was written specifically for Jet databases. If you're
starting to move your data to another DBMS, then it might make sense to move
some of your code to ADO, but there's no reason why you can't use both DAO
and ADO in the same application (I do it all the time when some of my data's
in Jet, and some's in SQL Server)

Don't believe stories that ADO is the way of the future: in actual fact,
development on it has been stopped in favour of ADO.Net.

 

[Guest]

Doug
thanks for that.
I guess the main reason for the conversion is for the
future migration of the db to SQL and I'm sure I read
somewhere that it would be necessary to go ado instead of
dao.

cheers
chris