I need some advice on setting up a small database which can be shared between two people within a small company.
First user : admin
second user: data input only
I am planning to split the database and placing the back end on the admins computer. The admin will have full access of the database.
The user will be responsible for only data inputting.
I am a beginner and not sure what would be the best and easiest way of sharing an access database between two computers. I want the database to be in sync between the users at all times. There is internet availability (Wi-Fi as well)in the company but no server. Also I want the second user to have limited access and shouldn't be able to change the database design or keys.
The database design is ready to be implement( all tables and relationships have been made)
I would really appreciate any advice from yourselves.