How to Design Database for Multiple Users

[waqas]

hi,


dear all experts before i am using only single user database without user name and password. i want to design a database for 5 to 8 users. can any one guide what should i do how to design database where i can see each entry, delete and editing by whom user.

[June7]

Start with a review of http://www.opengatesw.net/ms-access-...-Practices.htm

Then login form and user permissions are common topics in form. Search forum or google.

Start with http://www.mrexcel.com/forum/microso...ns-system.html

[waqas]

dear june7,
first i don't have an idea that from where i should start to design or create database for multiple user. where i can assign each user rights for inserting, deleting, updating, only viewing and uploading the data. i request you please guide me step by step by creating a small database from your side.
i highly appreciate for your help in this matter.

[June7]

I don't want to even try a step-by-step guidance and I am not going to build a database for you. Even if I wanted to I don't know your data and business practices. That's not what we are here for. There is already enough info 'out there'. Follow the articles referenced. Do research for more. When you encounter a specific issue post question.

Search forum on 'login form' - there are lots, many with samples attached.
https://www.accessforums.net/forms/m...orm-24841.html