G Guest Dec 5, 2006 #1 I would like to open one Access database from a form on another. Is the Shell function the best way to do this. - Thanks
I would like to open one Access database from a form on another. Is the Shell function the best way to do this. - Thanks
J Joan Wild Dec 5, 2006 #2 Yes it is. That or TSI SOON. See http://www.mvps.org/access/modules/mdl0005.htm
G Guest Dec 5, 2006 #3 If I use the Shell function - is there a way to send the user id and password that the original database was opened with along to the other Access database?
If I use the Shell function - is there a way to send the user id and password that the original database was opened with along to the other Access database?
J Joan Wild Dec 5, 2006 #4 Not without asking for their password again. See for an example of opening a secure mdb from an unsecure one. http://www.access.qbuilt.com/html/custom_login.html
Not without asking for their password again. See for an example of opening a secure mdb from an unsecure one. http://www.access.qbuilt.com/html/custom_login.html
