I'm hoping someone can help me with a newbie problem here...

I want to use a common dialog to allow a user to open a database. How do I get the database name and path from the common dialog and then open the database for use by some simple forms.

Thanks in advance.