I got a problem when I running the program done by the .NET web service. Firstly, I create a database by the Microsoft Access called k_base_1, and then I write a web service program (C# with OleDbDataadapter and dataset to deal with the database) to access the database and want to select all data from the database. But when I run the program, it gives me a warning msg saying that "it got no permission to open the database again or it already used (accessed) by another user". When I did dataset proview, it can access the database properly and get the right data that I want, and when I created the database connection, it also get test successfully. Finally, I check the database and found there is no other user using the database except me, so what else should I check with the problem. By the way, I will attach the screen shot with this message, and I will appreciate that anyone can do me a favor to solve it, thank you.
The warning message says:
The Comments of above Screen displayed as following:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:\Documents and Settings\Yunzhong Wang\My Documents\Visual Studio Projects\K_base_2.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at _1709.Service1.GetAll() in c:\inetpub\wwwroot\1709\service1.asmx.cs:line 206