hi,Everyone know this error? The database has been placed in state by user "Admin"!I am using a access databasesWhen more than one user has connect to one databases at the same time by using my program (vb.net), the following error message appears. "The database has been placed in a state by user 'Admin' on machine XXXXX that prevents it from being opened or locked."How to solve this error? please help!My following code as below:TryDB = New OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source=\\server\prdsystem\prdnsf.mdb;Persist Security Info=False; Mode=Share Deny None")DB.Open()Catch ex As ExceptionMsgBox(ex.Message, MsgBoxStyle.Information, "")EndFinallyDB.Close()End Try
Da = New OleDb.OleDbDataAdapter(sql, DB)Ds = New DataSetDa.Fill(Ds, "emp")dtp = Me.Ds.Tables(0)**Although I put the Persist Security Info=False; Mode=Share Deny None, still got the same error!Please help!