• Post Reply Bookmark Topic Watch Topic
  • New Topic

Getting single-threaded access to a Database  RSS feed

 
Douglas Kent
Ranch Hand
Posts: 171
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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...
 
Vernon Gibson
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!