Sunday, July 4, 2010

MS Access 2010 - Sharepoint Hosting

I have taken the giant step of upgradng to Microsoft Office 2010 and I love it. I did not upgrade to 2007 because I chose to wait for the second iteration of this major upgrade. For MS Access 2010, the major improvement and, in my opinion, move in the right direction, is the new Access Services that makes it possible to develop an application totally for the web and hosted on a MS Sharepoint server. Data is moving to the web, we know it and if we are smart, we will get ready to support it.

Here's how it works: In Access the developer must select "Web Database" option when starting the project. All forms, reports, Queries and events are developed with web compatibility. New macro functionality has been added to extend the capabilities. Access 2010 allows forms and reports to be published to web sites using what is called "access web services" that runs on Sharepoint software. These web based forms and reports run in any standard browser. Before publishing your project to the Sharepoint server, it is checked for compatibility and errors reported.

Many have voiced the concern that having to run in Sharepoint creates an expense and complication that will impede this usefulness. Honestly, I had this concern at first but here's what I decided: Any URL will have to be hosted somewhere and security, user-access, multi-user conflicts in tables, etc., will need to be handled somehow. Sharepoint does it effortlessly to the developer and there are many reasonably-priced hosting services out there. You can find 30-day free trials to host and demo sites to customers if needed as well. I have used www.accesshosting.com for such a demo and been happy.

12 comments:

  1. Thanks for the post... Must say very nice post....

    ReplyDelete
  2. I must admit i miss the old days where things were just a bit simpler and the software seemed much more straight forwards, i have office student 2007 and there is a update option but i will stay the same for the time being

    ReplyDelete
  3. Nice info............
    keep it................
    Funny CatPix

    ReplyDelete
  4. Thanks for the information. I guess looking some sites that would really help you is better.

    ReplyDelete
  5. is sharepoint practical for a start-up company? I know accessibility will be much easier, but what alternative would you suggest in case buying a license for sharepoint isn't practical?

    ReplyDelete
  6. Well done on this review. So pleased that you have shared this most reliable research work.

    ReplyDelete
  7. I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.

    ReplyDelete
  8. Taking some time to do some research and at the same time updated knowing a lot of changes are happening this days online is better.

    ReplyDelete
  9. Thanks for interesting post.its very useful post.
    http://plumbing-xspurts.ca

    ReplyDelete
  10. very useful post.
    Thanks for this lovely post.
    http://stores.ebay.com/Shears-and-Scissors

    ReplyDelete