how to browse and load mdb file from access 2000 form?

Hi guys. I want to design an access 2000 application that does the following.Inside a form
I want to be able brosse my hard disk and select an access mdb file . once i selected the db and click on ok,i want to be able to work on that mdb as if i opend it diretly. I be happy if some one teach me how to
create such browse mdb functionality. you can see the picture below.Thanks

http://i5.photobucket.com/albums/y18...roserfordb.jpg (pic of browse mdb option)

Just FYI. You are reinventing the wheel. There are plenty of lauchers available to do what you want.

How they work...

First you'll have to decide how you want to "browse your hard disk". Plenty of ways to do that. But you might want to check out the FileSystemObject for looking at "file system objects". This will give you a way to load file names to your form. There are also COM objects that you can use to pop up a file search dialog.

When you've chosen the method to provide the file name to the user, launching the database can be accomplished in several ways as well. How you do that will depend on how much control you want of the application that is launched from within the application that has the form that lists the files.

Check out the SHELL function for one possibility. Easy to launch your database but very difficult to control without using Windows API calls. That code can be as simple as:

Shell(your_file_name)

You could create your own instance of Access. This allows more control but you'll have to be careful not to destroy your instance of Access before the user is finished with the database. That code has some of this in it:

dim app as New Access.Application
app.OpenCurrentDatabase your_file_name
app.Visible = True
app.UserControl = True
' wait until the user is finished
set app = Nothing