Please help with password

[Al]

I have db1 and db2 many times the user needs to open db2
while they are in db1. Since the security is enforced, they
normally have to re-enter their user ID and Password. How
can I pass these 2 Pieces of info so that they can open db2
from within db1 without having to re-enter userid and
password?
Thank you
Al

 

[Joan Wild]

Sounds as though the two mdb files were secured using different mdw files.
(you could have secured them both using the same mdw). However, you should
be able to add the user to both mdw files (using the same name and PID).

 

[Al]

Dear Joan thank you for replying. No both databases are
using the same mdw file. I need to know what would be the
syntax to pass the currentuser ID and password to open db2
form db1.
thank you
Al

 

[Joan Wild]

Access security is session based. Once you login using a workgroup file,
that session of Access continues to use it. Just open the second database -
they've already entered the username/password for the session, so there
should be no problem.

 

[Al]

Joan, that is not what is happening here. let me explain
what actually happens. I have 2 databases they are both
using the same mdw file. I am now in one of them let us
call it db1. in one of the forms I have a cmd button with
the following path in its hyperlink address:
<E:\MDBs_02\ProgNotes.mdb>, when I click on it,
ProgNotes.mdb does not open automatically, instead I get
prompted with the log on dialog box having the userID
filled but I have to re-enter the password. What I want is
to bypass that dialog box either by passing the password
and userid or any other means.
Al

 

[Joan Wild]

I don't believe you can do that using a hyperlink. You could shell out to a
new instance of Access, and then close the first as in
http://www.mvps.org/access/modules/mdl0036.htm

or use Michael Kaplan's TSISoon
http://www.mvps.org/access/modules/mdl0005.htm