{"id":375,"date":"2011-10-06T19:03:00","date_gmt":"2011-10-06T17:03:00","guid":{"rendered":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/"},"modified":"2021-05-04T16:48:40","modified_gmt":"2021-05-04T14:48:40","slug":"from-access-to-sharepoint","status":"publish","type":"post","link":"https:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/","title":{"rendered":"From Access to SharePoint"},"content":{"rendered":"<p>Today I learnt you can move an Access database to SharePoint. You could do that since so much time ago!!! &#8230; I&#8217;m sure&#8230; but I learnt it today.<\/p>\n<p>SharePoint provides a service (named Access Service) that allow us to share and publish Access DBs in a web environment. This service is able to build a web site where:<\/p>\n<ul>\n<li>The Access tables are converted in SharePoint lists.<\/li>\n<li>The forms are converted in ASP.Net pages.<\/li>\n<li>Macros are converted in JavaScript.<\/li>\n<li>Access reports are converted in Sql Server Reporting Services.<\/li>\n<\/ul>\n<p>The creation of databases is done through the publication process to SharePoint from Access 2010 client.<\/p>\n<ul>\n<li>First, the SharePoint compatibility is checked (there is a compatibility check function)<\/li>\n<li>Second, execute &#8216;Publish Access Services&#8217; specifying the web site URL.<\/li>\n<li>Third, the central SharePoint administration service is activated<\/li>\n<\/ul>\n<p>Depending of the complexity of the data model, you can find performance issues with the proposed chosen architecture by SharePoint. In this case, you may want to consider the following approaches:<\/p>\n<ol>\n<li>Use the SQL Server up-sizing wizard. The data will be moved into a SQL Server instance, and the front end will remain as an Access client. It can work very well depending on the specifics of the application.<\/li>\n<li>You can try &#8216;Access Services&#8217; in SharePoint (requires Enterprise Edition). SharePoint lists are very good for simple flat table structures, if your Access schema is more complicated, it is better to go down the SQL Server route. If you really want to use SharePoint for the front end, move the data into SQL Server then surface it using either BCS (Enterprise again) or custom Web Parts, Silverlight etc.<\/li>\n<\/ol>\n<div class=\"separator\" style=\"clear: both; text-align: center;\"><a href=\"http:\/\/2.bp.blogspot.com\/-0pt8aVF0aN8\/To2oxTyBUGI\/AAAAAAAABiY\/ggOkaWhSKwo\/s1600\/DSC04062.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"240\" kca=\"true\" src=\"http:\/\/2.bp.blogspot.com\/-0pt8aVF0aN8\/To2oxTyBUGI\/AAAAAAAABiY\/ggOkaWhSKwo\/s320\/DSC04062.JPG\" width=\"320\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><em>(Rio Celeste, Costa Rica)<\/em><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Today I learnt you can move an Access database to SharePoint. You could do that since so much time ago!!! &#8230; I&#8217;m sure&#8230; but I learnt it today. SharePoint provides a service (named Access Service) that allow us to share and publish Access DBs in a web environment. This service is able to build a &#8230; <a title=\"From Access to SharePoint\" class=\"read-more\" href=\"https:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/\" aria-label=\"Read more about From Access to SharePoint\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[169],"class_list":["post-375","post","type-post","status-publish","format-standard","hentry","category-sharepoint","tag-microsoft"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>From Access to SharePoint -<\/title>\n<meta name=\"description\" content=\"Today I learnt you can move an Access database to SharePoint. You could do that since so much time ago!!! ... I&#039;m sure... but I learnt it today.SharePoint - joapen projects\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"From Access to SharePoint -\" \/>\n<meta property=\"og:description\" content=\"Today I learnt you can move an Access database to SharePoint. You could do that since so much time ago!!! ... I&#039;m sure... but I learnt it today.SharePoint - joapen projects\" \/>\n<meta property=\"og:url\" content=\"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/\" \/>\n<meta property=\"og:site_name\" content=\"joapen projects\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-06T17:03:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-04T14:48:40+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/2.bp.blogspot.com\/-0pt8aVF0aN8\/To2oxTyBUGI\/AAAAAAAABiY\/ggOkaWhSKwo\/s320\/DSC04062.JPG\" \/>\n<meta name=\"author\" content=\"joapen\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"joapen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/\"},\"author\":{\"name\":\"joapen\",\"@id\":\"https:\\\/\\\/joapen.com\\\/blog\\\/#\\\/schema\\\/person\\\/23919df2312175fe9c4609203595b217\"},\"headline\":\"From Access to SharePoint\",\"datePublished\":\"2011-10-06T17:03:00+00:00\",\"dateModified\":\"2021-05-04T14:48:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/\"},\"wordCount\":278,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/joapen.com\\\/blog\\\/#\\\/schema\\\/person\\\/23919df2312175fe9c4609203595b217\"},\"image\":{\"@id\":\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/2.bp.blogspot.com\\\/-0pt8aVF0aN8\\\/To2oxTyBUGI\\\/AAAAAAAABiY\\\/ggOkaWhSKwo\\\/s320\\\/DSC04062.JPG\",\"keywords\":[\"Microsoft\"],\"articleSection\":[\"SharePoint\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/\",\"url\":\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/\",\"name\":\"From Access to SharePoint -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/joapen.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/2.bp.blogspot.com\\\/-0pt8aVF0aN8\\\/To2oxTyBUGI\\\/AAAAAAAABiY\\\/ggOkaWhSKwo\\\/s320\\\/DSC04062.JPG\",\"datePublished\":\"2011-10-06T17:03:00+00:00\",\"dateModified\":\"2021-05-04T14:48:40+00:00\",\"description\":\"Today I learnt you can move an Access database to SharePoint. You could do that since so much time ago!!! ... I'm sure... but I learnt it today.SharePoint - joapen projects\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/#primaryimage\",\"url\":\"http:\\\/\\\/2.bp.blogspot.com\\\/-0pt8aVF0aN8\\\/To2oxTyBUGI\\\/AAAAAAAABiY\\\/ggOkaWhSKwo\\\/s320\\\/DSC04062.JPG\",\"contentUrl\":\"http:\\\/\\\/2.bp.blogspot.com\\\/-0pt8aVF0aN8\\\/To2oxTyBUGI\\\/AAAAAAAABiY\\\/ggOkaWhSKwo\\\/s320\\\/DSC04062.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/joapen.com\\\/blog\\\/2011\\\/10\\\/06\\\/from-access-to-sharepoint\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/joapen.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"From Access to SharePoint\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/joapen.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/joapen.com\\\/blog\\\/\",\"name\":\"joapen projects\",\"description\":\"Just a place to write\",\"publisher\":{\"@id\":\"https:\\\/\\\/joapen.com\\\/blog\\\/#\\\/schema\\\/person\\\/23919df2312175fe9c4609203595b217\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/joapen.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/joapen.com\\\/blog\\\/#\\\/schema\\\/person\\\/23919df2312175fe9c4609203595b217\",\"name\":\"joapen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/joapen.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/joapen-mini.jpeg\",\"url\":\"https:\\\/\\\/joapen.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/joapen-mini.jpeg\",\"contentUrl\":\"https:\\\/\\\/joapen.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/joapen-mini.jpeg\",\"width\":400,\"height\":400,\"caption\":\"joapen\"},\"logo\":{\"@id\":\"https:\\\/\\\/joapen.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/joapen-mini.jpeg\"},\"sameAs\":[\"http:\\\/\\\/www.joapen.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"From Access to SharePoint -","description":"Today I learnt you can move an Access database to SharePoint. You could do that since so much time ago!!! ... I'm sure... but I learnt it today.SharePoint - joapen projects","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/","og_locale":"en_US","og_type":"article","og_title":"From Access to SharePoint -","og_description":"Today I learnt you can move an Access database to SharePoint. You could do that since so much time ago!!! ... I'm sure... but I learnt it today.SharePoint - joapen projects","og_url":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/","og_site_name":"joapen projects","article_published_time":"2011-10-06T17:03:00+00:00","article_modified_time":"2021-05-04T14:48:40+00:00","og_image":[{"url":"http:\/\/2.bp.blogspot.com\/-0pt8aVF0aN8\/To2oxTyBUGI\/AAAAAAAABiY\/ggOkaWhSKwo\/s320\/DSC04062.JPG","type":"","width":"","height":""}],"author":"joapen","twitter_misc":{"Written by":"joapen","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/#article","isPartOf":{"@id":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/"},"author":{"name":"joapen","@id":"https:\/\/joapen.com\/blog\/#\/schema\/person\/23919df2312175fe9c4609203595b217"},"headline":"From Access to SharePoint","datePublished":"2011-10-06T17:03:00+00:00","dateModified":"2021-05-04T14:48:40+00:00","mainEntityOfPage":{"@id":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/"},"wordCount":278,"commentCount":0,"publisher":{"@id":"https:\/\/joapen.com\/blog\/#\/schema\/person\/23919df2312175fe9c4609203595b217"},"image":{"@id":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/#primaryimage"},"thumbnailUrl":"http:\/\/2.bp.blogspot.com\/-0pt8aVF0aN8\/To2oxTyBUGI\/AAAAAAAABiY\/ggOkaWhSKwo\/s320\/DSC04062.JPG","keywords":["Microsoft"],"articleSection":["SharePoint"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/","url":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/","name":"From Access to SharePoint -","isPartOf":{"@id":"https:\/\/joapen.com\/blog\/#website"},"primaryImageOfPage":{"@id":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/#primaryimage"},"image":{"@id":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/#primaryimage"},"thumbnailUrl":"http:\/\/2.bp.blogspot.com\/-0pt8aVF0aN8\/To2oxTyBUGI\/AAAAAAAABiY\/ggOkaWhSKwo\/s320\/DSC04062.JPG","datePublished":"2011-10-06T17:03:00+00:00","dateModified":"2021-05-04T14:48:40+00:00","description":"Today I learnt you can move an Access database to SharePoint. You could do that since so much time ago!!! ... I'm sure... but I learnt it today.SharePoint - joapen projects","breadcrumb":{"@id":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/#primaryimage","url":"http:\/\/2.bp.blogspot.com\/-0pt8aVF0aN8\/To2oxTyBUGI\/AAAAAAAABiY\/ggOkaWhSKwo\/s320\/DSC04062.JPG","contentUrl":"http:\/\/2.bp.blogspot.com\/-0pt8aVF0aN8\/To2oxTyBUGI\/AAAAAAAABiY\/ggOkaWhSKwo\/s320\/DSC04062.JPG"},{"@type":"BreadcrumbList","@id":"http:\/\/joapen.com\/blog\/2011\/10\/06\/from-access-to-sharepoint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/joapen.com\/blog\/"},{"@type":"ListItem","position":2,"name":"From Access to SharePoint"}]},{"@type":"WebSite","@id":"https:\/\/joapen.com\/blog\/#website","url":"https:\/\/joapen.com\/blog\/","name":"joapen projects","description":"Just a place to write","publisher":{"@id":"https:\/\/joapen.com\/blog\/#\/schema\/person\/23919df2312175fe9c4609203595b217"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/joapen.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/joapen.com\/blog\/#\/schema\/person\/23919df2312175fe9c4609203595b217","name":"joapen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/joapen.com\/blog\/wp-content\/uploads\/2021\/04\/joapen-mini.jpeg","url":"https:\/\/joapen.com\/blog\/wp-content\/uploads\/2021\/04\/joapen-mini.jpeg","contentUrl":"https:\/\/joapen.com\/blog\/wp-content\/uploads\/2021\/04\/joapen-mini.jpeg","width":400,"height":400,"caption":"joapen"},"logo":{"@id":"https:\/\/joapen.com\/blog\/wp-content\/uploads\/2021\/04\/joapen-mini.jpeg"},"sameAs":["http:\/\/www.joapen.com"]}]}},"_links":{"self":[{"href":"https:\/\/joapen.com\/blog\/wp-json\/wp\/v2\/posts\/375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/joapen.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/joapen.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/joapen.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/joapen.com\/blog\/wp-json\/wp\/v2\/comments?post=375"}],"version-history":[{"count":1,"href":"https:\/\/joapen.com\/blog\/wp-json\/wp\/v2\/posts\/375\/revisions"}],"predecessor-version":[{"id":5506,"href":"https:\/\/joapen.com\/blog\/wp-json\/wp\/v2\/posts\/375\/revisions\/5506"}],"wp:attachment":[{"href":"https:\/\/joapen.com\/blog\/wp-json\/wp\/v2\/media?parent=375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/joapen.com\/blog\/wp-json\/wp\/v2\/categories?post=375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/joapen.com\/blog\/wp-json\/wp\/v2\/tags?post=375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}