Using SharePoint as a Front-End for SQL Database

Posted on 2011-04-28
Last Modified: 2012-05-11
Experts ,
we have developed a SQL database which we use to track and maintain information about individual tasks we perform on projects.

We have developed front-end forms in MS Access to create and query task records from the SQL database. We use this database locally here in my office and it works quite well.

We would like to emulate the MS Access forms in SharePoint and use that as a front-end instead of using the forms that we have developed MS Access.

I would like to know the best way to go about this and which approach might be the best way to proceed. We would need to have read/write access to the SQL database. I understand that the Business Data Catalog would be one approach but I’m not sure if this the best approach given what we are trying to achieve. If this is the best approach, given we do not have programming skills, would we be able to implement this ourselves. Would the Collaborate Team offer services to construct a front-end?

Also, if there are tools already developed that would suit our needs, I would not want to reinvent the wheel on this.

Thanks for your time.

Question by:beesoo00
    LVL 38

    Expert Comment

    Look into Access Services of SharePoint 2010....
    LVL 38

    Accepted Solution


    Author Comment

    thanks a lot ACH ,, goood suggestion

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (…
    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…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 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

    8 Experts available now in Live!

    Get 1:1 Help Now