"Nubs" <bu******@gmail.comwrote
I have read that using the database splitter is good because it allows
multiple users to access the database simultaneously. However, is it
trully necessary to have multiple FE MDE files or can everyone just use
a single MDE file that is located on the network drive?
Firstly, that is not what allows multiple users to access the database
simultaneously. You can put a monolithic (unsplit) database on the server
and let all the users log in to that, and, much of the time, it will work.
But, when you do experience corruption, and that is likely, not only will
you need to restore the front-end, you'll have to recover your data (at
least, update it from the time of the last backup).
And, in addition to Marshall's comments, empirical evidence is that you
significantly increase the chance of corruption of any MDB (even a
front-end) when you have multiple users logged in at the same time. Then the
shared front-end will have to be restored, before _any_ user can access the
database.
So, I'd say, perhaps not necessary, but for many reasons, advisable.
Larry Linson
Microsoft Access MVP