I am writing an application where I need to assure that all updates to a Microsoft Access DB are single-threaded, using a "Singleton" (design pattern) Database broker object. All objects wanting to write to the DB will get a reference to the single broker object. How to assure one object at a time gets write access? Is synchronized code the best way to achieve this. Would one call "notifyall" at the end? THanks...
Douglas, Is it possible in Access to 'lock' records that are retrieved for update? Letting the database handle the sequence of events might be the best way to go. VG
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
subject: Getting single-threaded access to a Database