?
Solved

Web-enabling MSAccess apps

Posted on 2015-01-23
4
Medium Priority
?
81 Views
Last Modified: 2015-01-27
Hi

I have developed many MS Access 2010 apps. They have lots of VBA coding , upwards of 70K lines.

I understand that VBA wont run in a webpage, and that MS has augmented their macros (ugh) to aid in this area.

However, I'm unsure which approach would be the best for me to web-enable these apps. Initial research so far seems to indicate theres no easy conversion process.

So far the choices appear to be going with Sharepoint or using VS Studio (with ASP) and creating my webpages. I already have SQL server for the backend database

...or perhaps theres another option I havnt considered

I appreciate your thoughts in this

Thank you
0
Comment
Question by:HenryV1955
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 44

Assisted Solution

by:Rainer Jeschor
Rainer Jeschor earned 1000 total points
ID: 40567069
Hi,
I fully understand your concerns and issues. The aim of Access Web Apps has not been to replace Access but somehow to create an easy way of web enabling Access utilizing SharePoint (infrastructure). This comes with a lot of limitations - as you experienced.
From my point of view, you are already on a good way as you have already replaced the backend with SQL server engine. Now you have three options:
- You do not have much business logic and can life with the SharePoint limitations
- You create a web frontend based on ASP
Pro: language similar to VBA
Con: COM based, old technology, unpredictable future (especially on x64 systems)
- You create intelligent ASP.NET web application (in any of the existing styles like Web Forms, Razor, MVC, Web API,...)
Pro: Chance e.g. to create mobile frontends / HTML5/Javascript apps to be used on nearly any device
Con: New programming languages (HTML, Javascript, .NET)

It finally totally depends on you - but the overall trend goes to web applications and more and more towards mobility

Just my 2ct
Rainer
0
 

Author Comment

by:HenryV1955
ID: 40567174
Hi Rainer

Thanks for your candid comments. I like your thoughts. I'm also leaning the VS Studio, ASP.net web forms direction.

To be fair, I'll wait a bit longer and see if there are other responses

H
0
 
LVL 11

Accepted Solution

by:
Kelvin McDaniel earned 1000 total points
ID: 40569595
I also understand where you're coming from and agree with Rainer's comments.

I'll add that it depends on how much time you have to implement your first solution.  If you have the time, you're going to want to go with an MVC front end.

I won't lie, it has an HORRENDOUS learning curve for someone used to generated content but in the end it will be like breathing fresh, spring air after being cooped up with sick people for six months. And, you'll be able to replicate that success as many times as you need to for your other Access apps.

Just my $0.02.
0
 

Author Closing Comment

by:HenryV1955
ID: 40572848
Hi Rainer and Azarc3

Thanks for both of you for your candid comments.

You've both confirmed what I was thought would be the best approach

H
0

Featured Post

Linux Academy Android App Now Supports Chromecast

We have some fantastic news for our Android fans. We’re so excited to announce that the Linux Academy Android app is now available with Chromecast support. That’s right – simply download the latest update of the Linux Academy App and start casting your favorite course videos!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A publishing tool, a Version Control System, or a Collaboration Platform! These can be some of the defining words for the two very famous web-hosting Git repositories: Bitbucket and Github. Git is widely used amongst the programmers and developers f…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question