Forum Discussion
How to create Microsoft Access web app?
Web App are dead. Microsoft has killed off every web component of Access.
Depending on what exactly you are trying to achieve, there are a variety of options available to you
RDP
CITRIX
Terminal Services
SharePoint Backend (but this has major limits)
Use Azure as your backend
If your needs are simple enough PowerApps could be another option.
but truthfully, if the web is your goal, Access is simply the wrong tool for the job! You should use proper web technologies, such as PHP, .Net, MySQL, Azure, ...
Thank you so much for your reply. I appreciate your support. I am not a computer specialist but a school leader. I run my independent school and would like to add some IT systems to it.
Basically, what I want to do is to create a database that would have all data (Student Information/Management System), (Staff Management System), Client Information, etc...) All on the same database so that we can work with all data from one place. Also to be able to assign roles and permissions to who can access/change what.
If changes/access can be made online then my team from their remote locations can work on the systems. Also, if those systems can be put on a website, then even clients can add their information, requests etc..
I apologize for the long message. I hope you understand my situation and guide me on how I can do this.
Thanks.
- IMHO, Access simply will not fill this need and believe you will need to turn towards proper web technologies. That said such development has an extremely steep learning curve (html, CSS, JavaScript, jQuery, PHP, MySQL, ...) And typically not for the faint of heart. If this was a personal project, is say dig in, but for something for public use I think you should turn towards a professional developers.
Given the fact that this relational database application is intended for external use, as well as internal use, Access is a non-starter as a stand-alone solution. You can't expect your clients to use Access.
That said, there is room for a hybrid solution, IMO, with an in-house Access FE through which you can manage administrative tasks, create reports and similar functions using the same remote data source as the one driving your website.
Having implemented such a solution 12 or 12 years ago for a major University, I can say with confidence that a well-designed relational database solution combining the strengths of a desk-top Access interface and a web-browser interface can make for a strong solution.Again, though, the fact that your clients will judge the competence of the school on their experience means to me that this is not a suitable "first-time in Access" project.
