{"id":854,"date":"2016-08-26T14:24:03","date_gmt":"2016-08-26T19:24:03","guid":{"rendered":"http:\/\/accessusergroups.org\/sql-server-with-access\/?p=854"},"modified":"2016-10-17T16:47:59","modified_gmt":"2016-10-17T21:47:59","slug":"welcome-back","status":"publish","type":"post","link":"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/","title":{"rendered":"AVOID NUMBER CONFLICTS WITH SQL SEQUENCES"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>In case you missed out on the September meeting presented by Robert Aaron, we now have the recording available. \u00a0If you enjoy watching the recordings then register with the group and you will be notified of future meetings, that way you get the chance to meet with us online and ask questions!<a href=\"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-855 size-medium\" src=\"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences-300x150.jpg\" alt=\"Avoid-number-conflicts-with-SQL-Sequences\" width=\"300\" height=\"150\" srcset=\"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences-300x150.jpg 300w, https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences.jpg 600w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h6>About Robert Aaron<\/h6>\n<p>Robert has been working with Access since Version 2. He has\u00a0always loved how flexible it is and can be adapted to so many situations. Since he joined IT Impact, Inc.\u00a0a year ago he has\u00a0expanded his skills into SQL Server. \u00a0He believes Access and SQL Server are\u00a0a perfect combination for many things. Over the years he has\u00a0also done programming in other areas including writing 3 computer games that have been published. He is\u00a0continuing to expand his\u00a0knowledge in Access and SQL Server, and hopes\u00a0to bring you more interesting things along that journey.<\/p>\n<h3 class=\"author-name\"><\/h3>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/KXZKKWQRG7A?rel=0\" width=\"720\" height=\"405\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; In case you missed out on the September meeting presented by Robert Aaron, we now have the recording available. \u00a0If you enjoy watching the recordings then register with the group and you will be notified of future meetings, that way you get the chance to meet with us online and ask questions! &nbsp; &nbsp; [&hellip;]<\/p>\n","protected":false},"author":103,"featured_media":855,"comment_status":"open","ping_status":"closed","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>AVOID NUMBER CONFLICTS WITH SQL SEQUENCES - SQL Server with 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\/sql-server-with-access\/welcome-back\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AVOID NUMBER CONFLICTS WITH SQL SEQUENCES - SQL Server with Access - AccessUserGroups.org\" \/>\n<meta property=\"og:description\" content=\"&nbsp; In case you missed out on the September meeting presented by Robert Aaron, we now have the recording available. \u00a0If you enjoy watching the recordings then register with the group and you will be notified of future meetings, that way you get the chance to meet with us online and ask questions! &nbsp; &nbsp; [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Server with Access - AccessUserGroups.org\" \/>\n<meta property=\"article:published_time\" content=\"2016-08-26T19:24:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-10-17T21:47:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Susan Pyne\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/\",\"url\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/\",\"name\":\"AVOID NUMBER CONFLICTS WITH SQL SEQUENCES - SQL Server with Access - AccessUserGroups.org\",\"isPartOf\":{\"@id\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences.jpg\",\"datePublished\":\"2016-08-26T19:24:03+00:00\",\"dateModified\":\"2016-10-17T21:47:59+00:00\",\"author\":{\"@id\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/#\/schema\/person\/ac5d08948c70df3e3ac5e12de3272a62\"},\"breadcrumb\":{\"@id\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/#primaryimage\",\"url\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences.jpg\",\"contentUrl\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences.jpg\",\"width\":600,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AVOID NUMBER CONFLICTS WITH SQL SEQUENCES\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/#website\",\"url\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/\",\"name\":\"SQL Server with Access - AccessUserGroups.org\",\"description\":\"SQL Server with Access Virtual User Group\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/#\/schema\/person\/ac5d08948c70df3e3ac5e12de3272a62\",\"name\":\"Susan Pyne\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accessusergroups.org\/sql-server-with-access\/#\/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\/sql-server-with-access\/author\/susan-pyne\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AVOID NUMBER CONFLICTS WITH SQL SEQUENCES - SQL Server with 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\/sql-server-with-access\/welcome-back\/","og_locale":"en_US","og_type":"article","og_title":"AVOID NUMBER CONFLICTS WITH SQL SEQUENCES - SQL Server with Access - AccessUserGroups.org","og_description":"&nbsp; In case you missed out on the September meeting presented by Robert Aaron, we now have the recording available. \u00a0If you enjoy watching the recordings then register with the group and you will be notified of future meetings, that way you get the chance to meet with us online and ask questions! &nbsp; &nbsp; [&hellip;]","og_url":"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/","og_site_name":"SQL Server with Access - AccessUserGroups.org","article_published_time":"2016-08-26T19:24:03+00:00","article_modified_time":"2016-10-17T21:47:59+00:00","og_image":[{"width":600,"height":300,"url":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences.jpg","type":"image\/jpeg"}],"author":"Susan Pyne","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Susan Pyne","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/","url":"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/","name":"AVOID NUMBER CONFLICTS WITH SQL SEQUENCES - SQL Server with Access - AccessUserGroups.org","isPartOf":{"@id":"https:\/\/accessusergroups.org\/sql-server-with-access\/#website"},"primaryImageOfPage":{"@id":"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/#primaryimage"},"image":{"@id":"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/#primaryimage"},"thumbnailUrl":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences.jpg","datePublished":"2016-08-26T19:24:03+00:00","dateModified":"2016-10-17T21:47:59+00:00","author":{"@id":"https:\/\/accessusergroups.org\/sql-server-with-access\/#\/schema\/person\/ac5d08948c70df3e3ac5e12de3272a62"},"breadcrumb":{"@id":"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/#primaryimage","url":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences.jpg","contentUrl":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-content\/uploads\/sites\/2\/2016\/08\/Avoid-number-conflicts-with-SQL-Sequences.jpg","width":600,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/accessusergroups.org\/sql-server-with-access\/welcome-back\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/accessusergroups.org\/sql-server-with-access\/"},{"@type":"ListItem","position":2,"name":"AVOID NUMBER CONFLICTS WITH SQL SEQUENCES"}]},{"@type":"WebSite","@id":"https:\/\/accessusergroups.org\/sql-server-with-access\/#website","url":"https:\/\/accessusergroups.org\/sql-server-with-access\/","name":"SQL Server with Access - AccessUserGroups.org","description":"SQL Server with Access Virtual User Group","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/accessusergroups.org\/sql-server-with-access\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/accessusergroups.org\/sql-server-with-access\/#\/schema\/person\/ac5d08948c70df3e3ac5e12de3272a62","name":"Susan Pyne","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accessusergroups.org\/sql-server-with-access\/#\/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\/sql-server-with-access\/author\/susan-pyne\/"}]}},"_links":{"self":[{"href":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-json\/wp\/v2\/posts\/854"}],"collection":[{"href":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-json\/wp\/v2\/users\/103"}],"replies":[{"embeddable":true,"href":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-json\/wp\/v2\/comments?post=854"}],"version-history":[{"count":6,"href":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-json\/wp\/v2\/posts\/854\/revisions"}],"predecessor-version":[{"id":858,"href":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-json\/wp\/v2\/posts\/854\/revisions\/858"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-json\/wp\/v2\/media\/855"}],"wp:attachment":[{"href":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-json\/wp\/v2\/media?parent=854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-json\/wp\/v2\/categories?post=854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/accessusergroups.org\/sql-server-with-access\/wp-json\/wp\/v2\/tags?post=854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}