A lot of people would like to, but its impossible. Most apps doesn't allow several people to edit 1 file simultaniously.
Aha, precisely the point. This is no different for Access and the reason why we've been talking about splitting database in order to work within that simple fact that it's bad mojo to work upon same file simultaneously.
I suspect lot of confusion come from the fact that when they think of a database, they think of everyone accessing a single RDBMS so there should be no problem sharing data with several people, right?
Except... that's not actually the case. File access are still managed by daemon and the daemon is what we actually interact with while requesting & sending back data and it's up to the daemon to write those changes to the files, so at all time the files are actually managed by one user, and a automated user at that, too. We just work with that user (e.g. the daemon), which makes concurrency possible.
With Jet, there is no daemon (and of course there isn't. It would triple the complexity overnight if we were to require a daemon to manage Jet files even for a single user application), and it's more like a file server so the same restrictions we have upon .doc, .xls, and any other documents apply just as much as to .mdb/.accdb files.
Most of the pros lie in using SQL Server.
Most of the pros lie in owning a sledgehammer over a hammer.
An absurd statement, isn't it?
Several tools exist for a reason, and there is a reason why carpenter doesn't have just one kind of hammer but actually several kind of hammers as well an assortment of other tools. Same with the software- sometime Access is good enough for a 10-people business without resources for a full-time DBA or even a contractor to do a monthly maintenance.
Access really shines in its visibility because that same 10-people business still can use the same Access application even once they've moved into 1,000 people business with a full time DBA running dedicated RDBMS server, be it SQL Server, MySQL, Oracle, or whatever but they still have the same application they started out with; just a different data store.
