I have been referred to Power Apps from the Expressionweb Forum. I hope you can help me decide and/or guide me through replacing my database forms and (very rudimentary) apps that I have created in a (please don't laugh) FrontPage 2000 website. History:
My main domain website was originally built using Frontpage2000, which is/was a fully-integrated program that creates web pages as well as .asp pages tied to an onboard Access 2000 database. It was the database functionality of Frontpage (Database Wizard) that kept me locked into using the program. I have since "split up" my website into tow separate entities: The main, puiblic site, which was first switched over to an Expressionweb site, is now a WordPress site. However, I created a different domain to host a "temporary" Frontpage website to continue to handle all of the database functionality, with .asp pages that are privately accessible and some publicly accessible, with only a few links from the Wordpress site going to .asp forms that are non-updateable on the FP website. The two separate domains and websites are otherwise unconnected. It was first suggested that, to replace the currently hosted "back-end" administrative FP website, I should transition over to Visual Studio Express and migrate my Access2000 database into a SQL Server Express database, and re-build my forms with asp.net (The FrontPage Wizard created .asp pages). With VS I will have to recreate each page in asp.net manually. As I had switched over to Expressionweb for my main website (no database connectivity) I gained a small experience with css, style sheets, etc. before going over to Wordpress. However, it was also suggested on the Expressionweb forum that I check out Power Apps. I took a quick glance at the introductory Power App information, and maybe this will be a better solution...especially since I have started to create a series of actual "apps." (I guess that's what I should call them). They are basically update and review forms (in .asp) created in Frontage that are used by my partner-services, and are working well through their smart-phones. Can you give me a little guidance as to whether a Power App solution will work better than going through the learning curve of VS to re-create what I will need to replace my existing situation with the FrontPage website, which entails adding & updating records, etc.? I will still have to get away from my existing Access 2000 database...especially since Access2000 limits the amount of fields to 250 for any tables, and of course...Frontpage itself limits the amount of fields from a table or query that can be included in an .asp page itself. So I will need to go to a more advanced database regardless. I never checked out if later versions of Access have the same limitations.