Shell Function

[Len]

I have an Access database that is calling another Access database using the
shell function with the full path of Access, the mdw file, user name and
password. Currently a user name and password is put in the code. I would like
to capture the user id and password, insert it in the shell function and pass
it to the called Access database. I am able to capture the user name using
the CurrentUser() function but have not been able to figure out how to
capture the password. Thanks.

 

[Alex Dybenko]

Hi,
not sure that you can capture password, perhaps you can build a table to
store login/password and get it from there, but this is not a good way
either

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Tim Ferguson]

I am able to capture the user name using
the CurrentUser() function but have not been able to figure out how to
capture the password. Thanks.

That's the whole point of passwords, you can't read them! If there was a
way of doing that then the whole security thing would be out of the window.

If you really need to open a second instance of Access, then I think you'll
just have to get another password for it. If you want to get at the data,
then you can open the mdb in the same workspace as the first one and it
will inherit the same security environment. Assuming the mdbs belong to the
same workgroup, of course.

HTH


Tim F