>Hey Mark, how's it going these days? I sure miss my Texas! I heard that the Richland Rebels are no longer called the Richland Rebels due to the controversy over the Confederate flag. Oh well...
>
>Anyway, what would you do if you had a combobox on your form that would change your database and file to another path? How would you implement this?
>
>(1) Close the database
>(2) Re-open the DBC and the files you need for the form?
>(3) What else?
>
>I'm not quite getting back to the right DBC somehow in my code.

You have to close all tables and views in all data sessions first. I would do this by forcing the user to have all forms closed before this options was even made available. You can never close a database when any of its tables or views are still open. Once that is done, then you can successfully close the database. At this point you should be able to successfully open any database you want.