Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Posts
    13

    Question Unanswered: Getting record state via ADO for multi-user DB

    Hello,

    I have a small issue to deal with.


    I have a 'server database' that holds a few different tables. I'll basically dumb it down to this:

    tblOldPrices
    tblNewPrices

    The 'client db' connects to the 'tblOldPrices' and downloads the latest information. Each entry from tblOldPrices gets corrected, and the record is added to tblNewPrices and deleted from tblOldPrices.

    I basically need to know via ADO, how to I get the state of tblOldPrices? I am thinking I may get some errors because someone may be 'reading' from the tblOldPrices at the exact same time someone is trying to update a price. Much thanks!

  2. #2
    Join Date
    May 2005
    Posts
    13
    Anyone for this?

Posting Permissions

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