I encountered a strange problem yesterday. When I was testing a project, I wanted to operate a table in the ACCESS database. But when I wanted to open its design view, a warning was prompted that the modification was not allowed! It indicates that a view is being bound to this data table and cannot be operated now! Strange! I have never encountered such a problem. Can't I modify this table? The table is always locked. After half a day, you can only go to bed later. I can't continue my research today, but I can only check it online. I finally saw someone on the internet saying that the connection to the database was not closed, I don't believe it because I used to use SQL, even if I forgot to close the database connection. So I opened my test page and found that the database was not closed and the data reader and data connection were not closed. So I immediately wrote the closed statement and re-tested it! This time !! The database has finally recovered from being unlocked, and the tables I want to operate on can also be properly designed. The stone falls into the ground, the original data is not closed in time will appear such a horrible result, did not pay attention to the past, it seems that in the future really want to develop a good habit. So I wrote an article immediately. I hope I can help my friends who have had such experiences. Don't laugh at me if they have watched it. Although I am only a newbie, I still hope this article can help some friends.
I hope you will become a good habit in the future. Please remember to close the database in time after you use it. Otherwise, ......