the database has been placed in state by user "Admin"
-
hi, Everyone know this error? the database has been placed in state by user "Admin"! We are using a shared database in access databases. When more than one user has connect to my databases by my application (my program developed by vb.net) at the same time, 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." * Although i already add the "Persist Security Info=False;Mode=Share Deny None" in my OleDbConnection, it still got same error! How to solve this error? please help! My following code as below: Try DB = New OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source=C:\prdsystem\prdnsf.mdb; Persist Security Info=False;Mode=Share Deny None") DB.Open() Catch ex As Exception MsgBox(ex.Message, MsgBoxStyle.Information, "") End End Try Da = New OleDb.OleDbDataAdapter(sql, DB) Ds = New DataSet Da.Fill(Ds, "emp")