Fantastic, thank you everyone, I think a split database is the way to go forward, easier to upgrade the FE without any complications and allows user to share it with other users on a network. I will look through the links suggested for that.
My next question is, if I add an extra field or table...