• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 628
  • Last Modified:

Using SharePoint as a Front-End for SQL Database

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.

  • 2
1 Solution
Justin SmithSr. System EngineerCommented:
Look into Access Services of SharePoint 2010....

beesoo00Author Commented:
thanks a lot ACH ,, goood suggestion

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now