New User - Looking for best option to share Access DB front-end using MS Teams
Office 365 Cloud Based - Sharepoint, MS Teams, MS Access - Windows 11 server (not dev.). I'm building a database in Access to store various document names and their corresponding processing instructions. I would like Team/Channel members to have permission-based access through the Teams app to be able to perform certain actions. At lowest level permissions, access means the ability to use the database through Teams to search for a given document name to retrieve the processing instructions for their level. At the highest permissions level, access means being able to make changes to select tables in the database. They may add/mod/delete the Document Names and the corresponding processing instructions. Can someone please help me with it? I don't want to spend too much time building out the database if it can't be used as an information resource for everyone. I would be grateful for any assistance, including a point toward good information that might help a novice like me to understand how to best accomplish this? All other users on our network (also Team members on my Channel) have the same software that I do, including those designated as Team Owners. Please let me know if any needed information is missing. Thanks in advance for your assistance!! :)