Open a new mdb from code

I need to open a database from my VBA code.
1) Close my current database (I cant open up a new copy of Access because Im using workgroup security and dont want the user to have to put in the password again)
2) Open up a new database inside the current copy of Access.

3) I can do what I want with send keys  however I dont like it  Is there a better way.
       SendKeys "^o" & " H:\GreatApp\MyApp.mdb" & "~", False

----------------- Below is why  not any added info -----------------
OK  if you get this far you might be asking why is this crazy fool wanting to open up a database from inside VBA.  The below is the answer and as always I welcome comments on my craziness.  You dont need to read below to answer the above question  but if you must know go further.

My clients have the frontend mdb on their C drive and the data on a network.  I normally design databases that often have temp tables in the frontend mdb to put data in before I run a report.  In addition I will output Excel spreadsheets to the users local C drive.

Now that I have developed an application for a company they have their C: drives locked and dont give the users any specific space on the network.  THEY DONT WANT TO CHANGE.  So to make my application work on the network where if two users happen to run the same report that use the temp table at the same time  I need a separate mdb for each user.

The solution.

Have a database with just one object  a function that does the following.
1)      gets the users name (CurrentUser)  eg Joe Blow
2)      See if there is a frontend database in the folder with the current users name.
H:\GreatApp\Joe Blow\ MyApp.mdb
If not  Create a folder  -->  H:\GreatApp\Joe Blow
Copy the application from H:\GreatApp\MyApp.mdb  to H:\GreatApp\Joe Blow \MyApp.mdb
3)      With the current copy of Access (remember we opened it using Access workgroup security)
Close the small mdb
Open H:\GreatApp\Joe Blow \MyApp.mdb