I just want to make sure that if many users open the form at the same time and input their data the database won't crash or the data won't get save.
Maybe much ado about nothing? If each user has their own FE, then technically, they are not using the same form, they're using a version of it.
Secondly, if they're all entering data into the same table(s) at the same moment, so what? They're not on an existing record because the record being worked on doesn't exist. As long as they're not trying to import data from the same place, or aren't entering data directly in the table, there shouldn't be an issue?
Lastly, if concerned about the possibility that 2 or more concurrent users are trying to edit or delete the same record, then use pessimistic record locking on the form. Or am I over simplifying the problem?
I see this as a record locking issue (if it's an issue at all) and don't believe that matters if the shared db is a single or each user has their own.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.