Open access from VB

Dear ladies and gentleman,


I am using VB6.0 and Access 97. I am trying to open access Databas.mdb.
This Database has a password. I did try to use Shell command but I found shell command work only for the EXE file and also I can not open it Automatically without typing the password. The reason I am using that way to run the report from Access Database.

Dim RetVal
RetVal = Shell("C:\Directorname\Databas.mdb")


Also is it possible to run command to know if the database or my VB application is running or not in Access 97 and VB6.0.

Thanks for your help.

Jim

[Vandana Sood]

depends on what ure using for dataccess (ODBC,ADO???) U need to configure system DSN for data access and then use Open Connection or an equivalent function depending on what ure usingand pass the DSN and UserID and pwd to it.
Regards,
Vandana