The databse splitter is a routine in Access that actually creates a new database and then imports the tables/data/relationships into that database and links the frontend to the tables
The routine then deletes the table objetcs from the "frontend" db
This is designed so that multiple users can run the frontend locally and just manipulate the data on the centralized PC
Think of it as rudimentary client/server
As for two users conflicting with each other this would be a rarity
It is more likely (yet still unlikely) that this will happen with editing and not data entry. What are the odds of two users accessing the same record to make a change at the same time?
As for data entry - each time a user makes a "request" to insert data , Access will alot x amount of "block" size to do this - so a conflict here is not feasable unless two users at the same time try to assign the same value to a primary key in a table.