问题描述
我刚刚使用SSMS创建了一个新的数据库文件，然后尝试使用Data Source应用程序将其附加到新的Windows Form Application。当我浏览到数据文件（.mdf）时，我收到一条错误消息，指出我没有权限使用此文件。所以，我进去并更改了数据文件的权限。当我想要再次附加新数据库时，我收到另一条错误消息正在使用的文件。输入新名称或关闭在另一个程序中打开的文件。在调查中我发现该文件在SQL Server中是打开的，我不知道如何关闭它。我在Windows 10 Pro上使用SQL Server Express 2014，Visual Studio Community 2017 Visual Basic。我如何克服这个？
我尝试过：
正如我所说，我不知道如何解决它。
I just created a new database file using SSMS and then tried to attach it to a new Windows Form Application using the Data Source app. When I Browse to the data file (.mdf) I got an error message stating I didn't have permission to use this file. So, I went in and changed the permissions on the data file. The when I want back to again attach the new database I get another error message, "File in use. Enter a new name or close the file that's open in another program." In investigating I find that the file is open in the SQL Server and I have no idea how to close this. I am using SQL Server Express 2014, Visual Studio Community 2017 Visual Basic on Windows 10 Pro. How do I overcome this?
What I have tried:
Just what I've stated, I have no Idea how to fix it.
推荐答案
这篇关于将新数据库文件附加到Windows窗体应用程序时出现问题。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！