{"id":243,"date":"2018-12-02T20:03:14","date_gmt":"2018-12-02T18:03:14","guid":{"rendered":"http:\/\/msaccess.pl\/?p=243"},"modified":"2020-06-24T14:42:56","modified_gmt":"2020-06-24T12:42:56","slug":"polaczenie-do-ms-sql-server-w-ms-access-cz-1","status":"publish","type":"post","link":"https:\/\/msaccess.pl\/msaccess\/?p=243","title":{"rendered":"Po\u0142\u0105czenie do MS SQL Server w MS Access cz.1"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\n\nCz\u0119sto potrzebujemy dosta\u0107 si\u0119 do zewn\u0119trznego \u017ar\u00f3d\u0142a danych r\u00f3\u017cnego pochodzenia. Na przyk\u0142adzie MS SQL Server opowiadam o podstawowych sposobach komunikacji mi\u0119dzy MS Access a zewn\u0119trznymi bazami danych. Przedstawiam poj\u0119cia takie jak &#8222;tabela po\u0142\u0105czona&#8221; i &#8222;kwerenda przekazuj\u0105ca&#8221;. Pokazuj\u0119 jak po\u0142\u0105czy\u0107 si\u0119 do danych z tabeli, widoku, procedury i funkcji tabelarycznej.\n\n<\/p>\n\n\n<p><!--more--><\/p>\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" width=\"1000\" height=\"563\" src=\"https:\/\/www.youtube.com\/embed\/anQtZHwsxIY?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Cz\u0119sto potrzebujemy dosta\u0107 si\u0119 do zewn\u0119trznego \u017ar\u00f3d\u0142a danych r\u00f3\u017cnego pochodzenia. Na przyk\u0142adzie MS SQL Server opowiadam o podstawowych sposobach komunikacji mi\u0119dzy MS Access a zewn\u0119trznymi bazami danych. Przedstawiam poj\u0119cia takie jak &#8222;tabela po\u0142\u0105czona&#8221; i &#8222;kwerenda przekazuj\u0105ca&#8221;. Pokazuj\u0119 jak po\u0142\u0105czy\u0107 si\u0119 do danych z tabeli, widoku, procedury i funkcji tabelarycznej.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,14,10],"tags":[],"class_list":["post-243","post","type-post","status-publish","format-standard","hentry","category-analiza-danych","category-projektowanie-aplikacji","category-tutorial"],"_links":{"self":[{"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/posts\/243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=243"}],"version-history":[{"count":1,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/posts\/243\/revisions"}],"predecessor-version":[{"id":244,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/posts\/243\/revisions\/244"}],"wp:attachment":[{"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}