Solved

Web-enabling MSAccess apps

Posted on 2015-01-23
4
73 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
  • 2
4 Comments
 
LVL 44

Assisted Solution

by:Rainer Jeschor
Rainer Jeschor earned 250 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:
azarc3 earned 250 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

A Change in PHP Behavior with Session Write Short Circuit (http://php.net/manual/en/book.session.php#116217) (Winter 2014)** With the release of PHP 5.6 the session handler changed in a way that many think should be considered a bug.  See the note …
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This video teaches users how to migrate an existing Wordpress website to a new domain.
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.

746 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now