I'm setting up several secured databases to be shared over a netwrok. For people to log in using a user name from the system.mdw, i've had to set up separate shortcuts for each person, because access seems to be installed in different directories on several machines.
I want to be able to use a "Gateway" database that a user could open with out worrying about security. From this database, they would select which of the three (currently) databases they wanted to use. The Gateway database would read the path of the running Access application on the fly, and open the desired database, pointing to the appropiate system.mdw.
What I'm having problems with is figuring out how to open a database from within Access using VBA with the command-line options. I'm guessing I could either gigure out how to pass them as arguments somehow, or cobble together a string to pass to window's run command (is that possible?).
I want to be able to use a "Gateway" database that a user could open with out worrying about security. From this database, they would select which of the three (currently) databases they wanted to use. The Gateway database would read the path of the running Access application on the fly, and open the desired database, pointing to the appropiate system.mdw.
What I'm having problems with is figuring out how to open a database from within Access using VBA with the command-line options. I'm guessing I could either gigure out how to pass them as arguments somehow, or cobble together a string to pass to window's run command (is that possible?).
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")