My windows forms application allows a user to create and save a variety of data using a multi-document interface. To save the data, I created a local database (Visual Basic in Visual Studio Express 2012, SQL Server 2012, .mdf) using these instructions:
http://msdn.microsoft.com/en-us/library/vstudio/ms233763.aspx. The application works fine and modifies and saves database entries.
The application also allows the user to open a different database to work on. I accomplish this by changing the connection string using this line:
My.Settings("ProjectDatabaseConnectionString") = NewConnectionString
The application has no problem connecting and saving to the specified database.
Here is where I am stuck. If the application accesses a database .mdf file, the file may not be moved, deleted or renamed until the application is closed. If the user “opens” twenty databases, t ...
Go to the complete details ...