•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Database where everyone can enter new data but once entered only one person can edit/delete
Our take
Creating a database that allows multiple users to enter data while restricting edit and delete permissions to a single individual is entirely feasible. This approach not only fosters collaboration but also ensures that records remain intact and reliable. By implementing user roles and permission settings, you can designate one person as the sole editor, protecting vital information from accidental changes. This structure is ideal for tracking daily activities while maintaining compliance with record-keeping requirements. Explore this solution to enhance your team's data management efforts effectively.
Is there a way to create a database where numerous people can enter data but once entered, it's only editable or able to be deleted by one person? I am in charge of creating a way for staff to log daily activities an want to make sure it can't get altered or deleted by accident since keeping the records for a certain amount of time is required
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#real-time data collaboration#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#rows.com#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Excel compatibility#real-time collaboration#Excel alternatives#database#editable#delete#data entry