Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ConnectionPoolilng from MS Access

 
jonathan Greens
Ranch Hand
Posts: 139
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Is there a free ConnectionPooling manager for MS access?
thanks!
 
Tom Blough
Ranch Hand
Posts: 263
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Connection pooling is not DB specific. A very good opensource connection pool library is available from Apache.


Cheers,
 
Maximilian Xavier Stocker
Ranch Hand
Posts: 381
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If I could just add... the term Connection Pooling is not really suitable when using Access. If you have to use Access that's fine but connection pooling sounds like you are trying to use it an enterprise style fashion for which it is not a suitable DB solution.
 
jonathan Greens
Ranch Hand
Posts: 139
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
why is access not suitable for interprise db?
 
Maximilian Xavier Stocker
Ranch Hand
Posts: 381
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by jonathan Greens:
why is access not suitable for interprise db?


Because it is a desktop database product. You can use it for some simple applications yes but it is NOT suitable for heavy use.

Among the problems

-single threaded and single locking. to write any rows the whole database must be locked thus only one write operation at any one time can happen
-no transactions
- not scalable to large sizes
- does not really support multiple users (see first point) instead connections are essentially queued up one by one
- does not have enterprise level DB features for features like backup and recovery
- very limited support for stored procedures

Now again Access is a fine product when it is used appropriately. But because it was designed as a desktop product it is not suitable for the enterprise environment because it has the limitations above.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic