Converting the tables to SQL Server does not seem to be too difficult but, converting the FE to a web application appears to be a huge undertaking. Am I correct that you would have to recreate all queries, forms and reports, and rewrite all VBA code?
You are correct. The front-end has to be completely rebuilt with whatever technology you want to use. If you want your users to interact with the Access front-end, you can send them that. If you want a web portal, you need to design it in something like ASP. Microsoft has a new tool out to connect Access to their "Dataverse" and Power Portal. I'm just now starting to explore that myself, so my review will be coming out soon. But in the mean time, read this.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Server Lessons.
