Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012

    Unanswered: Access on Sharepoint

    Hi, I'm looking to create a web based Database in Access 2010 and publish it to a sharepoint so it runs as a web based DB.

    Would I need an enterprise hosting plan to support this?

    Also, can anybody suggest a good sharepoint hosting site.
    I came across accesshosting but want to see what other options I have

    Thank you...

  2. #2
    Join Date
    Nov 2011
    Currently in Kabul Afghanistan
    I would say use caution in joining the two Access and SharePoint. There are a lot of things you can do in Access quickly that can not easily be done in SharePoint. We have a copy of the data from a list in SharePoint being mirrored to MS Access. The danger is that if you delete a record or change a record in Access it can and usually does affect the record set in SP. That said, we encourage all of our users to input data into SharePoint and limit the views they can have and edit rights. (I am sure you know this). What we do is just make a "copy" of the SharePoint list and export it into Access. What you will find is that Access will NOT be normalized and that if you have look up or rather Choice type fields in SharePoint that the look up values are stored in the LookUp property of the field in Access, where ideally you would have a normalized table set in Access for looking up values. The Dog should wag the tail, not the other way around. As a best practice, consider using SharePoint as your system of record. Follow it in Access by going to a view in a List, and exporting the View into Access by selecting Actions / Open With Access. Store the Access DB where the common user can't get to it. You as the administrator can then form queries in Access quickly to give you information that you don't have stored in a "View" in SP. One other note, when you decide to add fields in SharePoint, other drop down lists, Date Fields etc. Open Access (the one copy you made) and right click on the table name and select Refresh. This should bring the new columns into Access nicely.

    "The Dog" is SharePoint, "The Tail is Access". The two work well together...but caution caution caution is advised. Hope this helps...

    As far hosting solutions go, there are tons of them out there. Hope I did not go too far...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts