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...
posted 15 years ago
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