Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Question Unanswered: exclusion on DAO

    Hi, I'm just starting to program DAO in Visual C++ 6.0 and a question come to me when I wanted to make the same DB accessed from multiple locations: thing is that the dirty detect feature doesn't solve my problem, I need that no one can access the same record (for example when in one computer it's been edited and in the other is been consulted).
    I really don't know how this kind of problems are solve in database applications, I just read something about optimistic and pessimistic locking on the recordsets but the article (on MSDN) talked about "pages" on the recordset and I couldn't find more info on this subject.
    I'll thank any tip you can give me since I'm quite lost.

    Thank you
    Diego

  2. #2
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251
    maybe you have specific reason, why you need DAO, but generally say, I'd go for ADO, it has better ways how to handle recordsets (DAO does not have cursor location)... DAO is old way and exept few details, it's almost dead.


    Microsoft has pretty good ADO cursors or locks descriptions.....

    check this - chapter 8:
    http://msdn.microsoft.com/library/en...ction1_ado.asp


    and this for comparison
    http://msdn.microsoft.com/library/en...oadoupdate.asp


    jiri

  3. #3
    Join Date
    Jan 2003
    Posts
    2

    thank you for your answer

    Actually I realize what you are saying after I had started the project and had invested a lot of time on it, and since I have to deliver the application on a few weeks it'd be quite hard to change at this time so I'd be thankfull for any suggestions on DAO.

    Thank you
    Diego

Posting Permissions

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