Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Visual Basic
  4. the database has been placed in state by user "Admin"

the database has been placed in state by user "Admin"

Scheduled Pinned Locked Moved Visual Basic
2 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Offline
    C Offline
    charleslau2855
    wrote on last edited by
    #1

    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)the database open, 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: Try DB = New OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source=C:\prdsystem\prdnsf.mdb") 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")

    M 1 Reply Last reply
    0
    • C charleslau2855

      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)the database open, 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: Try DB = New OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source=C:\prdsystem\prdnsf.mdb") 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")

      M Offline
      M Offline
      Marcus J Smith
      wrote on last edited by
      #2

      Googled it[^] :-D


      CleaKO

      "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
      "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups