Is MS Access (JET) suitable for multiuser access?

by

There is so much misinformation in the answers in this thread that I don’t know where to start. I just spent 4 points in reputation voting down the answers with misleading and wrong information in them.

  1. the Jet database engine (which is all that’s involved here, as the OP clarified with an edit) is by default multi-user — it was built from the ground up to be that way.

  2. sharing a Jet data store is very reliable when the network is not substandard. This means not a WAN and not wireless, because the bandwidth has to be sufficient for Jet to maintain the LDB file (for multi-user locking), which means a ping by your local PC’s instance of the Jet database engine once per second (with default settings), and because Jet can’t recover from a dropped connection (which is quite common in a wireless environment).

  3. the situation where Access falls down is when a front-end Access application MDB is shared (which is not the case for this poster). The reason it fails is because you’re sharing things that can’t be reliably shared and have no reason to be shared. Because of the way Access objects are stored in an MDB file (the entire Access project is stored in a single BLOB field in one record in one of the system tables), it’s very prone to corruption if multiple users open it. In my estimation, sharing an Access front end (or an unsplit MDB with the tables and forms/reports/etc. all in one MDB) is the source for 99.99% of corruptions of Access/Jet files.

My basic answer to the OP’s question is that, yes, Jet would be a great data store for an app of that size. However, if there’s any possibility at all for the user population to grow above 25, then it might be better to start off from scratch with a database engine that is more robust at higher user populations.

More Related Contents:

  1. Setting up an MS-Access DB for multi-user access
  2. How do i add percentage an Access query?
  3. How does one decompile and recompile a database application?
  4. How do you use version control with Access development?
  5. What are the rules governing usage of parenthesis in VBA function calls?
  6. Microsoft Access condense multiple lines in a table
  7. Code to loop through all records in MS Access
  8. Syntax error in insert into statement – what’s the error?
  9. Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb
  10. Why is my query not updateable?
  11. Microsoft Access DBEngine.OpenDatabase() breaks for Network-Paths – Error 3050
  12. Is it possible to create a recursive query in Access?
  13. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  14. What is the equivalent of Select Case in Access SQL?
  15. How do I access the selected rows in Access?
  16. Access 2007 – Left Join to a query returns #Error instead of Null
  17. Pivot Query in MS Access
  18. insert query with sequential primary key
  19. VBA procedure to import csv file into access
  20. how to show query results in a datasheet in the same form?
  21. Selecting 2 tables from 2 different databases (ACCESS)
  22. MS Access prepared statements
  23. Linked table ms access 2010 change connection string
  24. How can I modify a saved Microsoft Access 2007 or 2010 Import Specification?
  25. Null values for variables in VBA
  26. MS Access query returning Chinese characters – possible table corruption?
  27. Using a centralized VBA module in multiple Access databases
  28. How to execute a query in ms-access in VBA code?
  29. How to add a menu item to the default right click context menu
  30. Force all users to disconnect from 2010 Access backend database

Leave a Comment