{"id":529,"date":"2017-03-28T17:41:06","date_gmt":"2017-03-28T22:41:06","guid":{"rendered":"http:\/\/accessusergroups.org\/lunch\/?p=529"},"modified":"2017-03-30T16:30:04","modified_gmt":"2017-03-30T21:30:04","slug":"march-presentation-follow-up-notes-from-our-q-a-session","status":"publish","type":"post","link":"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/","title":{"rendered":"March presentation &#8211; follow up notes from our Q &amp; A session"},"content":{"rendered":"<p>To answer Gorgio&#8217;s question on the video for how to upgrade Access application to use a SQL Server backend at 26:46:<\/p>\n<p>I was trying to demonstrate how the SQL Server migration assistant would add a new database to SQL server from Access.\u00a0 While I was testing prior to the presentation, I ran the migration assistant and created both of the databases for practice.\u00a0 I had removed one of them (the contacts database) but I had forgotten to remove the time and billing database.\u00a0 I did so live so that I could then demo the creation of it using the migration assistant.\u00a0 My apologies for the confusion!<\/p>\n<p>&nbsp;<\/p>\n<p>To answer Phil&#8217;s question regarding using a filter on a form with something like a LastName which contains an apostrophe:<\/p>\n<p>Once I got the syntax right on the form sample I was working up, the 2 single quotes worked fine.\u00a0 I questioned Phil about it, and he and Cindy had since worked together and determined the problem was actually caused by the type of quote mark he was using in the filter. He was not aware there were different versions of the single quote and is now looking at using the ascii code for single quotes to clear this up.\u00a0 Here is a link <a href=\"https:\/\/accessusergroups.org\/lunch\/wp-content\/uploads\/sites\/13\/2017\/03\/Getting-Past-Doh-More-Than-One-Quote-VBA.pdf\">Getting Past Doh More Than One Quote VBA <\/a>to a write up Phil was kind enough to do on the topic and quote differences.<\/p>\n<p>Good catch to both of you!\u00a0 I definitely HAVE run into the different quotes issue before \u2013 not in Access but in SQL.\u00a0 Depending on what type of editor you are using, some use one type of quote and some the other.\u00a0 Frustrating I know.\u00a0 Good things to watch out for!<\/p>\n<p>&nbsp;<\/p>\n<p>Thanks again to everyone for joining us today!\u00a0 The video should be posted in a couple of days and I will create another blog post and a facebook entry when George is able to provide more path migration information for the Access Web Apps retirement.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To answer Gorgio&#8217;s question on the video for how to upgrade Access application to use a SQL Server backend at 26:46: I was trying to demonstrate how the SQL Server migration assistant would add a new database to SQL server from Access.\u00a0 While I was testing prior to the presentation, I ran the migration assistant [&hellip;]<\/p>\n","protected":false},"author":126,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"mc4wp_mailchimp_campaign":[],"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>March presentation - follow up notes from our Q &amp; A session - Lunchtime - 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\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"March presentation - follow up notes from our Q &amp; A session - Lunchtime - AccessUserGroups.org\" \/>\n<meta property=\"og:description\" content=\"To answer Gorgio&#8217;s question on the video for how to upgrade Access application to use a SQL Server backend at 26:46: I was trying to demonstrate how the SQL Server migration assistant would add a new database to SQL server from Access.\u00a0 While I was testing prior to the presentation, I ran the migration assistant [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/\" \/>\n<meta property=\"og:site_name\" content=\"Lunchtime - AccessUserGroups.org\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-28T22:41:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-03-30T21:30:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/accessusergroups.org\/lunch\/wp-content\/uploads\/sites\/13\/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=\"mbarnesatbbs\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"mbarnesatbbs\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/\",\"url\":\"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/\",\"name\":\"March presentation - follow up notes from our Q &amp; A session - Lunchtime - AccessUserGroups.org\",\"isPartOf\":{\"@id\":\"https:\/\/accessusergroups.org\/lunch\/#website\"},\"datePublished\":\"2017-03-28T22:41:06+00:00\",\"dateModified\":\"2017-03-30T21:30:04+00:00\",\"author\":{\"@id\":\"https:\/\/accessusergroups.org\/lunch\/#\/schema\/person\/7d9af2b0f69547fb79c1d6dcc45c179a\"},\"breadcrumb\":{\"@id\":\"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/accessusergroups.org\/lunch\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"March presentation &#8211; follow up notes from our Q &amp; A session\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/accessusergroups.org\/lunch\/#website\",\"url\":\"https:\/\/accessusergroups.org\/lunch\/\",\"name\":\"Lunchtime - AccessUserGroups.org\",\"description\":\"Lunchtime Virtual Access User Group\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/accessusergroups.org\/lunch\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/accessusergroups.org\/lunch\/#\/schema\/person\/7d9af2b0f69547fb79c1d6dcc45c179a\",\"name\":\"mbarnesatbbs\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accessusergroups.org\/lunch\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dee83f49215c7d60d126dc887f7b5314?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dee83f49215c7d60d126dc887f7b5314?s=96&d=mm&r=g\",\"caption\":\"mbarnesatbbs\"},\"url\":\"https:\/\/accessusergroups.org\/lunch\/author\/mbarnesatbbs\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"March presentation - follow up notes from our Q &amp; A session - Lunchtime - 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\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/","og_locale":"en_US","og_type":"article","og_title":"March presentation - follow up notes from our Q &amp; A session - Lunchtime - AccessUserGroups.org","og_description":"To answer Gorgio&#8217;s question on the video for how to upgrade Access application to use a SQL Server backend at 26:46: I was trying to demonstrate how the SQL Server migration assistant would add a new database to SQL server from Access.\u00a0 While I was testing prior to the presentation, I ran the migration assistant [&hellip;]","og_url":"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/","og_site_name":"Lunchtime - AccessUserGroups.org","article_published_time":"2017-03-28T22:41:06+00:00","article_modified_time":"2017-03-30T21:30:04+00:00","og_image":[{"width":1200,"height":675,"url":"https:\/\/accessusergroups.org\/lunch\/wp-content\/uploads\/sites\/13\/2023\/04\/aug-share.png","type":"image\/png"}],"author":"mbarnesatbbs","twitter_card":"summary_large_image","twitter_misc":{"Written by":"mbarnesatbbs","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/","url":"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/","name":"March presentation - follow up notes from our Q &amp; A session - Lunchtime - AccessUserGroups.org","isPartOf":{"@id":"https:\/\/accessusergroups.org\/lunch\/#website"},"datePublished":"2017-03-28T22:41:06+00:00","dateModified":"2017-03-30T21:30:04+00:00","author":{"@id":"https:\/\/accessusergroups.org\/lunch\/#\/schema\/person\/7d9af2b0f69547fb79c1d6dcc45c179a"},"breadcrumb":{"@id":"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/accessusergroups.org\/lunch\/march-presentation-follow-up-notes-from-our-q-a-session\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/accessusergroups.org\/lunch\/"},{"@type":"ListItem","position":2,"name":"March presentation &#8211; follow up notes from our Q &amp; A session"}]},{"@type":"WebSite","@id":"https:\/\/accessusergroups.org\/lunch\/#website","url":"https:\/\/accessusergroups.org\/lunch\/","name":"Lunchtime - AccessUserGroups.org","description":"Lunchtime Virtual Access User Group","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/accessusergroups.org\/lunch\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/accessusergroups.org\/lunch\/#\/schema\/person\/7d9af2b0f69547fb79c1d6dcc45c179a","name":"mbarnesatbbs","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accessusergroups.org\/lunch\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dee83f49215c7d60d126dc887f7b5314?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dee83f49215c7d60d126dc887f7b5314?s=96&d=mm&r=g","caption":"mbarnesatbbs"},"url":"https:\/\/accessusergroups.org\/lunch\/author\/mbarnesatbbs\/"}]}},"_links":{"self":[{"href":"https:\/\/accessusergroups.org\/lunch\/wp-json\/wp\/v2\/posts\/529"}],"collection":[{"href":"https:\/\/accessusergroups.org\/lunch\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/accessusergroups.org\/lunch\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/accessusergroups.org\/lunch\/wp-json\/wp\/v2\/users\/126"}],"replies":[{"embeddable":true,"href":"https:\/\/accessusergroups.org\/lunch\/wp-json\/wp\/v2\/comments?post=529"}],"version-history":[{"count":0,"href":"https:\/\/accessusergroups.org\/lunch\/wp-json\/wp\/v2\/posts\/529\/revisions"}],"wp:attachment":[{"href":"https:\/\/accessusergroups.org\/lunch\/wp-json\/wp\/v2\/media?parent=529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/accessusergroups.org\/lunch\/wp-json\/wp\/v2\/categories?post=529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/accessusergroups.org\/lunch\/wp-json\/wp\/v2\/tags?post=529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}