Say we have a secured Access Database.
1) Using ADO what code can I use to validate the USER and GROUP?
2) What sort of VB6 code do I need to create new USERS and GROUPS?
3) How do I tell my application which MDW to use?

Workspace and DBEngine were there in DAO where it was possible to address the above issues. What can I do with ADO. I know there is UserName and Password in the ConnectString property of the Connection Object but I have not been able to use it.

Sample code would be appreciated.