I'm using a dataenvironment in VB6. I want to open a password
protected MS Access 2K DB without code, just using the vb6
functionalities of the DEnv. I have tried many things, always getting
the same error. I'm placing the correct password on the connection
field were the password should be. The User is Admin. I thing a lot of
ppl out there have run into the same problem. But, I haven't been able
to find an accurate answer on Searchers nor MS msdn.

Any help or hint will be greatly appreciated

Thanks a LOT for your time

I'm using a dataenvironment in VB6. I want to open a password
protected MS Access 2K DB without code, just using the vb6
functionalities of the DEnv. I have tried many things, always getting
the same error. I'm placing the correct password on the connection
field were the password should be. The User is Admin. I thing a lot of
ppl out there have run into the same problem. But, I haven't been able
to find an accurate answer on Searchers nor MS msdn.

There are two types of Access security, user-level and database password. If you're using a simple
database password then you do not need to specify the user ID and user ID password. The article
below contains some examples of connection strings that implement both user-level and database
password security:

HOWTO: Open a Secured Access Database in ADO Through OLE DB
http://support.microsoft.com/default.aspx?scid=http://support.microso...

Microsoft MVP (Visual Basic)