Currently I close the connection to my database and then try to select the database in the open file dialog but Windows tells me: "This file is in use, close the file..."
If I've closed my db connection what else do I need to do to completely close the file so I can select it in the openfiledialog?
It can depend a lot on where the db file is, e.g. is it in your project? is it in your sql server data folder?