Bill Ross
asked on
Convert MS Access to Web App
We need to convert part of our MS Access DB to a web app. ASPX or .net. No experience in web apps. Ideas?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or you can use an Access FE with an Azure BE (if you have good bandwidth), and if you need mobile, and it doesn't have to be extensive, you could use Power Apps for the mobile portion of things.
ASKER
Thanks guys. Our MS application has been used for many years - 20 screens - 50 reports - SQL backend. I think I need to hire someone to help as the learning curve is too long and I'm crazy busy. There used to be a "hire an expert" section but i can't find it on the new EE layout.
it might be easier to install your app on a server and access this server using remote desktop.
ASKER
I have it set up that way on Azure now but it's becoming a distribution/new user set up pain - especially for my Apple users. I've got 100+ users and RDP licenses are killing me.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys. I'll check it out.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Problem is that some users have Apple and others have slow connection. The RDP/VM solution woirks fine but with 100+ users the cost to MS for RDP sessions is huge.
ASKER
BE and FE are on Azure now. Works great - just very expensive long term.
Daniel, you missed the part about a lot of Apple users and RemoteDesktop costing an arm and a leg.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to all. I'm looking down the road a year or so. Maybe even port parts to web at a time.
Bill
Bill
The RDP client is included in the "pro" versions of Windows so there is no extra charge. There is no help for Apple users but that was Apple's deliberate choice to be incompatible with the PC world. That's why few corporations make the effort to support small numbers of Apple users.
I don't know if Citrix ends up being cheaper than RDP if you run your own server but Citrix is what most of my clients use. That should allow all users to work with the app as long as they have a compatible browser.
I don't know if Citrix ends up being cheaper than RDP if you run your own server but Citrix is what most of my clients use. That should allow all users to work with the app as long as they have a compatible browser.
First start with moving the BE to the Cloud ( a VPS costs a few dollars and the performance can be great)...even on experimental stage...little by little you can move on ...for start creating simple HTML/PHP pages that show a few data to the users without having to connect..probably by just pushing data to the cloud database...no manipulation...no interaction,,,just using them to feed the pages i mentioned before...like reports...then you start to really use this BE...along the way you start isolating the logic (maybe you already have) so you could migrate them to another platform (.NET, PHP,Node.js)...
ASKER
Thank you all for your help and advice. I'm investigating a redo.
Web and all the technologies is a wonderful and vast world with limitless possibilities BUT it does require quite some learning/programming/testi
Just pick a technology that should follow to the end and start reading....probably ASP .NET Core is your best bet as Ms really tries to gather everything under one roof....but do start from the basics : HTML ,CSS...every technology around eventually boils down to prepare a BIG text file (html) that a browser will render and display the "magic"