I'm currently using the following code to connect to an access mdb:

Set cnResources = New ADODB.Connection
cnResources.ConnectionString = "DSN=Resources"

Where Resources is the mdb file. Just recently, security access has been implemented in the database via workgroups/usergroups. How do I modify my code so that I am able to connect to the mdb file and create queries in VB6? I've already created a form where the user can log-in and enter his user name and password. Hoping for your advice. Thanks.


Ramon