I'm a database manager in a growing company. My boss is pretty savvy with data too. He occasionally creates spreadsheets or Access databases. These would be better with collaboration. We need total CRUD power over these databases. And we need the interface to be online, so we can access it from anywhere.

So far, we have taken existing applications and rewritten them in the LAMP model. While this approach leads to versatile online applications, it's kind of slow, and since I'm the only person in my company who is a coder, all that work ends up bottle-necking through my office.

I am considering Share Point Server as a way to publish our MS applications. I'm hoping this would allow some of the other people in our organization (who are skilled in the MS suite) to create applications, publish them, and have remote users read & update our data.

Does anyone know if Share Point makes this possible? Any advice or personal experience with Share Point would be appreciated.

  • If this is going to be accessible through the extranet then licencing will be an issue. That's something that will likely play a big factor as it's not all that cheap. Having said that, SharePoint sounds like it fits the model of what you're looking for once your business powerusers get used to the technology as you can just give them SharePoint Designer and/or InfoPath access and let them pretty much build their own apps.
    – Servy
    Commented May 15, 2012 at 18:30

2 Answers 2


You should definitively give a try to SharePoint 2010 foundation which is the free version that you can safely deploy on on x64 Windows 2008 (ideally R2) server.

You can even use your existing access databases and make them available from SharePoint through the Business Connectivity Services which is also part of the SP Foundatation package.

You'll enjoy creating your data model straigh within SharePoint and that will give you much more freedom than a custom LAMP solution, mainly regarding extranet scenario, ensuring proper security schema for the CRUD operations and scalability in case you start having a bunch of users accessing & collaborating on theses databases.

Hope it helped.


You may want to take a look at SharePoint Workspace 2010 (part of the MS Office 2010 Professional Plus edition) which integrates with the MS Office Suite and also SharePoint servers.

Update: Another alternative to consider is the hosted services of Office 365 which offers both Office & SharePoint benefits.

  • Thanks guys, both of these comments were helpful. Is there a light-weight version of sharepoint we could test this on? Or a company who offers hosting for a sharepoint server? I don't think we are interested in setting up a local server.
    – GRY
    Commented May 15, 2012 at 18:55
  • I have updated my above response with Office 365 link. Commented May 15, 2012 at 19:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.