{"id":950,"date":"2014-10-03T17:18:52","date_gmt":"2014-10-03T22:18:52","guid":{"rendered":"http:\/\/accessusergroups.org\/?p=950"},"modified":"2014-10-03T19:58:01","modified_gmt":"2014-10-04T00:58:01","slug":"stored-procedures-in-ms-access","status":"publish","type":"post","link":"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/","title":{"rendered":"Stored Procedures in MS Access"},"content":{"rendered":"<p>In September Juan Soto, Access MVP, presented at the <strong>Chicago Access User Group (<a href=\"http:\/\/caug.com\/\" target=\"_blank\">CAUG<\/a>), <\/strong>on\u00a0the topic of<strong> Stored\u00a0Procedures\u00a0in MS Access. \u00a0<\/strong>Once again he will be sharing his knowledge on this subject by speaking at the Access User Group meetings for Latino and Espa\u00f1a. Both these meetings will be held in Spanish.<\/p>\n<p>Take your Access skills to the next level and discover new tricks, such as:<\/p>\n<ul>\n<li><strong>How to use stored procedures as a report source or as part of your code.<\/strong><\/li>\n<li><strong>How to maximize performance between SQL Server and Access.<\/strong><\/li>\n<\/ul>\n<p>It this is a topic that interests you, and you have not yet done so, register with the group to receive information of future meetings.<\/p>\n<p><strong>This is our regular monthly meeting link.\u00a0<\/strong><\/p>\n<p><strong>Join the meeting:\u00a0<a href=\"https:\/\/join.me\/accessusergroups\" target=\"_blank\">https:\/\/join.me\/accessusergroups<\/a><\/strong><\/p>\n<p><strong>Spain\u00a0on Thursday, October 16 at 21:00 CEST<\/strong><br \/>\n<strong>Latin America on Wednesday, October 15 at 18:30 CTD<\/strong><\/p>\n<p>On a computer, use any browser with Flash. Nothing to download.<br \/>\nOn a phone or tablet, launch the\u00a0<a href=\"https:\/\/join.me\/app\" target=\"_blank\">join.me app<\/a>\u00a0and enter meeting code:\u00a0842-599-774<\/p>\n<p><strong>Join the audio conference:\u00a0<\/strong><br \/>\nDial a phone number and enter access code, or connect via internet.<\/p>\n<p><strong>By phone:\u00a0<\/strong><br \/>\nUnited States\u00a0\u00a0\u00a0<strong>+1.213.226.1066<\/strong><br \/>\nAccess Code\u00a0\u00a0<strong> 842-599-774#<\/strong><\/p>\n<p><a href=\"https:\/\/join.me\/intl\" target=\"_blank\">Other international numbers are available<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In September Juan Soto, Access MVP, presented at the Chicago Access User Group (CAUG), on\u00a0the topic of Stored\u00a0Procedures\u00a0in MS Access. \u00a0Once again he will be sharing his knowledge on this subject by speaking at the Access User Group meetings for Latino and Espa\u00f1a. Both these meetings will be held in Spanish. Take your Access skills [&hellip;]<\/p>\n","protected":false},"author":103,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"mc4wp_mailchimp_campaign":[],"footnotes":""},"categories":[1],"tags":[8,7],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Stored Procedures in MS Access - AccessUserGroups.org<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Stored Procedures in MS Access - AccessUserGroups.org\" \/>\n<meta property=\"og:description\" content=\"In September Juan Soto, Access MVP, presented at the Chicago Access User Group (CAUG), on\u00a0the topic of Stored\u00a0Procedures\u00a0in MS Access. \u00a0Once again he will be sharing his knowledge on this subject by speaking at the Access User Group meetings for Latino and Espa\u00f1a. Both these meetings will be held in Spanish. Take your Access skills [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/\" \/>\n<meta property=\"og:site_name\" content=\"AccessUserGroups.org\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/AccessUserGroups\" \/>\n<meta property=\"article:published_time\" content=\"2014-10-03T22:18:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-10-04T00:58:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2023\/04\/aug-share.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Susan Pyne\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@AccessUserGroup\" \/>\n<meta name=\"twitter:site\" content=\"@AccessUserGroup\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Susan Pyne\" \/>\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\":\"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/\"},\"author\":{\"name\":\"Susan Pyne\",\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/person\/ac5d08948c70df3e3ac5e12de3272a62\"},\"headline\":\"Stored Procedures in MS Access\",\"datePublished\":\"2014-10-03T22:18:52+00:00\",\"dateModified\":\"2014-10-04T00:58:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/\"},\"wordCount\":206,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/accessusergroups.org\/#organization\"},\"keywords\":[\"Access\",\"Stored Procedures\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/\",\"url\":\"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/\",\"name\":\"Stored Procedures in MS Access - AccessUserGroups.org\",\"isPartOf\":{\"@id\":\"https:\/\/accessusergroups.org\/#website\"},\"datePublished\":\"2014-10-03T22:18:52+00:00\",\"dateModified\":\"2014-10-04T00:58:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/accessusergroups.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Stored Procedures in MS Access\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/accessusergroups.org\/#website\",\"url\":\"https:\/\/accessusergroups.org\/\",\"name\":\"AccessUserGroups.org\",\"description\":\"Virtual Access User Groups\",\"publisher\":{\"@id\":\"https:\/\/accessusergroups.org\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/accessusergroups.org\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/accessusergroups.org\/#organization\",\"name\":\"Access User Groups\",\"url\":\"https:\/\/accessusergroups.org\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png\",\"contentUrl\":\"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png\",\"width\":1011,\"height\":260,\"caption\":\"Access User Groups\"},\"image\":{\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/AccessUserGroups\",\"https:\/\/twitter.com\/AccessUserGroup\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/person\/ac5d08948c70df3e3ac5e12de3272a62\",\"name\":\"Susan Pyne\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accessusergroups.org\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4ffbaa6e6f4e682364c27b9f21ffd05b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4ffbaa6e6f4e682364c27b9f21ffd05b?s=96&d=mm&r=g\",\"caption\":\"Susan Pyne\"},\"description\":\"I started with the firm as a Sales Assistant and over the years worked my way up to Senior Access developer, I\u2019m certified on Power BI, with more certifications coming. I'm also the chapter coordinator for AccessUserGroups.org, a worldwide organization of Access virtual chapters that meet each month online to discuss a range of topics in different languages. I LOVE working with Access and learning new technologies!\",\"url\":\"https:\/\/accessusergroups.org\/blog\/author\/susan-pyne\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Stored Procedures in MS Access - AccessUserGroups.org","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":"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/","og_locale":"en_US","og_type":"article","og_title":"Stored Procedures in MS Access - AccessUserGroups.org","og_description":"In September Juan Soto, Access MVP, presented at the Chicago Access User Group (CAUG), on\u00a0the topic of Stored\u00a0Procedures\u00a0in MS Access. \u00a0Once again he will be sharing his knowledge on this subject by speaking at the Access User Group meetings for Latino and Espa\u00f1a. Both these meetings will be held in Spanish. Take your Access skills [&hellip;]","og_url":"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/","og_site_name":"AccessUserGroups.org","article_publisher":"https:\/\/www.facebook.com\/AccessUserGroups","article_published_time":"2014-10-03T22:18:52+00:00","article_modified_time":"2014-10-04T00:58:01+00:00","og_image":[{"width":1200,"height":675,"url":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2023\/04\/aug-share.png","type":"image\/png"}],"author":"Susan Pyne","twitter_card":"summary_large_image","twitter_creator":"@AccessUserGroup","twitter_site":"@AccessUserGroup","twitter_misc":{"Written by":"Susan Pyne","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/#article","isPartOf":{"@id":"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/"},"author":{"name":"Susan Pyne","@id":"https:\/\/accessusergroups.org\/#\/schema\/person\/ac5d08948c70df3e3ac5e12de3272a62"},"headline":"Stored Procedures in MS Access","datePublished":"2014-10-03T22:18:52+00:00","dateModified":"2014-10-04T00:58:01+00:00","mainEntityOfPage":{"@id":"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/"},"wordCount":206,"commentCount":0,"publisher":{"@id":"https:\/\/accessusergroups.org\/#organization"},"keywords":["Access","Stored Procedures"],"articleSection":["Blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/","url":"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/","name":"Stored Procedures in MS Access - AccessUserGroups.org","isPartOf":{"@id":"https:\/\/accessusergroups.org\/#website"},"datePublished":"2014-10-03T22:18:52+00:00","dateModified":"2014-10-04T00:58:01+00:00","breadcrumb":{"@id":"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/accessusergroups.org\/blog\/stored-procedures-in-ms-access\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/accessusergroups.org\/"},{"@type":"ListItem","position":2,"name":"Stored Procedures in MS Access"}]},{"@type":"WebSite","@id":"https:\/\/accessusergroups.org\/#website","url":"https:\/\/accessusergroups.org\/","name":"AccessUserGroups.org","description":"Virtual Access User Groups","publisher":{"@id":"https:\/\/accessusergroups.org\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/accessusergroups.org\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/accessusergroups.org\/#organization","name":"Access User Groups","url":"https:\/\/accessusergroups.org\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/","url":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png","contentUrl":"https:\/\/accessusergroups.org\/wp-content\/uploads\/2021\/10\/logo.png","width":1011,"height":260,"caption":"Access User Groups"},"image":{"@id":"https:\/\/accessusergroups.org\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/AccessUserGroups","https:\/\/twitter.com\/AccessUserGroup"]},{"@type":"Person","@id":"https:\/\/accessusergroups.org\/#\/schema\/person\/ac5d08948c70df3e3ac5e12de3272a62","name":"Susan Pyne","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accessusergroups.org\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4ffbaa6e6f4e682364c27b9f21ffd05b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ffbaa6e6f4e682364c27b9f21ffd05b?s=96&d=mm&r=g","caption":"Susan Pyne"},"description":"I started with the firm as a Sales Assistant and over the years worked my way up to Senior Access developer, I\u2019m certified on Power BI, with more certifications coming. I'm also the chapter coordinator for AccessUserGroups.org, a worldwide organization of Access virtual chapters that meet each month online to discuss a range of topics in different languages. I LOVE working with Access and learning new technologies!","url":"https:\/\/accessusergroups.org\/blog\/author\/susan-pyne\/"}]}},"_links":{"self":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/posts\/950"}],"collection":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/users\/103"}],"replies":[{"embeddable":true,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/comments?post=950"}],"version-history":[{"count":4,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/posts\/950\/revisions"}],"predecessor-version":[{"id":962,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/posts\/950\/revisions\/962"}],"wp:attachment":[{"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/media?parent=950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/categories?post=950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/accessusergroups.org\/wp-json\/wp\/v2\/tags?post=950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}