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

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

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