Results 1 to 3 of 3

Thread: DataBase concurrency

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 1999
    Location
    España
    Posts
    45

    DataBase concurrency

    Hello kids.

    I've a trouble in na app, I use an Access Database conected by ADO.NET and direct commands and transactions. The database is accessed by a network. When the app is running alone there is no problem but if I try the same app in two PCs appears a trouble about locked tables.

    I need to use concurrency but I don't know how. Please, Help Me!

  2. #2
    New Member
    Join Date
    Nov 2002
    Location
    Argentina
    Posts
    5

    Smile Hi

    If you are from España, you speak spanish!

    No conozco la solución para tu problema, pero, si adjuntas una copia del código, quizas alguien te podría ayudar.

    Yo estoy comenzando a utilizar VS.NET (I am a beginner).

    en otra ocasión sería de mucha ayuda alguien del mismo idioma.

  3. #3
    Frenzied Member
    Join Date
    Oct 2002
    Location
    Gammapolis
    Posts
    1,474
    with my very little knowledge about ADO.NET and VB.NET it seems that if you use datasets they wont lock your tables.
    From MSDN
    In ADO.NET you open connections only long enough to perform a database operation, such as a Select or Update. You can read rows into a dataset and then work with them without staying connected to the data source. In ADO the recordset can provide disconnected access, but ADO is designed primarily for connected access.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width