Unanswered: Getting record state via ADO for multi-user DB
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:
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!