Yes, the rest would be in the second one and links to tables in the backend instead of having the tables actually in that file.
Do NOT run the frontend from the server and EACH USER should have a copy on THEIR COMPUTER. Otherwise you will have problems including a much greater chance of...