Is it possible to replicate advanced Access functionality (created using VBA and SQL stmts) using Sharepoint Developer?

Posted on 2014-08-08
Last Modified: 2014-08-09
I use VBA and SQL statements to access recordsets, update data, retrieve data, display pop up forms, etc. Can this same functionality be created using SharePoint Developer?
Question by:newbie46
    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    I not sure what "Sharepoint Developer" is - can you explain further?

    If you're referring to 2013 Web Apps, then no you cannot use standard VBA methods to do any of these things. Web Apps can use the macro language only, and it's somewhat limited compared to what you can do with macros in a desktop Access app. If your application needs are fairly non-complex, then a Web App may be the right platform.
    LVL 74

    Accepted Solution

    Not a Sharepoint expert but...

    From what I understand, Sharepoint uses Visual Studio as it's platform, my guess is that you can do the same things as you can in Access, addition to a lot more.

    Just not that MS access development is a "Desktop" environment.
    Sharepoint is geared more for the web.

    So the User interface will be quite different.

    For example, in a web app, you typically don't have multiple forms open that you can move around on the screen.

    Just know that moving from Access to sharepoint development requires a totally different way of thinking.
    Sharepoint is not just a "more advanced" version of VBA, is a different platform altogether.

    Some things will be similar, ... Loops, variables, controls, ...etc
    But things need to be much more structured than in Access.

    Access is classified as a "Rapid Application Development" platform.

    So a good Access developer can throw together a basic app in a few days.
    This will NOT be the case for a similar app created in Sharepoint.

    The average Access developer opening up Visual Studio for the first time will be totally lost.

    When you move to Sharepoint you are typically moving to Web development.


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    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…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now