Refreshing a linked table (housed on MS SQL Server) now breaks - Microsoft: Access Tables and Relationships

<!DOCTYPE html> <html id="XF" lang="en-US" dir="LTR" data-app="public" data-template="thread_view_type_question" data-container-key="node-700" data-content-key="thread-1807066" data-logged-in="false" data-cookie-prefix="xf_" data-csrf="1732703716,d82100fcac964718dda3931694b416f9" class="has-no-js template-thread_view_type_question XenBase layout-classic style-light sidebar-right xb-toggle-default xb-sidebar-show" > <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=Edge" /> <meta name="viewport" content="width=device-width, initial-scale=1, viewport-fit=cover">  <script> var dimensionValue1 = 'Programmers'; var dimensionValue2 = 'DBMS Packages'; var dimensionValue3 = 'Microsoft: Access Tables and Relationships'; window.dataLayer = window.dataLayer || []; window.dataLayer.push({ 'Area' : dimensionValue1, 'Category' : dimensionValue2, 'Forum' : dimensionValue3 }); </script>   <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-MMC9PJ9');</script>   <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-TZQ8TVZR');</script>   <script type="text/javascript"> adroll_adv_id = "KCG7QJRNGNEX3GEZSJPEFG"; adroll_pix_id = "HNHCAFVMNNC7FBZP3GMMLE"; adroll_version = "2.0"; (function(w, d, e, o, a) { w.__adroll_loaded = true; w.adroll = w.adroll || []; w.adroll.f = [ 'setProperties', 'identify', 'track', 'identify_email' ]; var roundtripUrl = "https://s.adroll.com/j/" + adroll_adv_id + "/roundtrip.js"; for (a = 0; a < w.adroll.f.length; a++) { w.adroll[w.adroll.f[a]] = w.adroll[w.adroll.f[a]] || (function(n) { return function() { w.adroll.push([ n, arguments ]) } })(w.adroll.f[a]) } e = d.createElement('script'); o = d.getElementsByTagName('script')[0]; e.async = 1; e.src = roundtripUrl; o.parentNode.insertBefore(e, o); })(window, document); adroll.track("pageView"); </script> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4401622383960692" crossorigin="anonymous"></script>   <script async src="https://securepubads.g.doubleclick.net/tag/js/gpt.js"></script> <script> window.googletag = window.googletag || {cmd: []}; googletag.cmd.push(function() { var pathParts = window.location.pathname.substr(1).split('/'); var mapLeaderboard = googletag.sizeMapping() .addSize([1024, 200], [728, 90]) .addSize([0, 0], [300, 250]) .build(); var mapWallpaper = googletag.sizeMapping() .addSize([1024, 200], [1, 1]) .addSize([0, 0], [[1, 1]]) .build(); var gptSlots = []; googletag.defineSlot('/5272491/dw_network/tektips_customsearchbox', [300, 90], 'div-gpt-tektips_customsearchbox').addService(googletag.pubads()); gptSlots[1] = googletag.defineSlot('/5272491/dw_network/tektips_thread1', [728, 90], 'div-gpt-tektips_thread1').defineSizeMapping(mapLeaderboard).addService(googletag.pubads()); gptSlots[2] = googletag.defineSlot('/5272491/dw_network/tektips_thread2', [728, 90], 'div-gpt-tektips_thread2').defineSizeMapping(mapLeaderboard).addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_thread3', [[728, 90]], 'div-gpt-tektips_thread3').addService(googletag.pubads()); gptSlots[3] = googletag.defineSlot('/5272491/dw_network/tektips_wallpaper', [1, 1], 'div-gpt-tektips_wallpaper').defineSizeMapping(mapWallpaper).addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_sidebar1', [[300, 250], [300, 600]], 'div-gpt-tektips_sidebar1').addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_sidebarbottom', [[300, 250], [300, 600]], 'div-gpt-tektips_sidebarbottom').addService(googletag.pubads()); googletag.pubads().enableSingleRequest(); googletag.pubads().collapseEmptyDivs(); googletag.pubads().setTargeting('articletitle', pathParts[0] ? pathParts[0] : 'home-page'); googletag.enableServices(); }); </script>  <title>Refreshing a linked table (housed on MS SQL Server) now breaks - Microsoft: Access Tables and Relationships | Tek-Tips</title> <link rel="manifest" href="/webmanifest.php"> <meta name="theme-color" content="#647ec4" /> <meta name="apple-mobile-web-app-title" content="Tek-Tips Information Technology Professional Forums"> <meta name="description" content="We had a former developer who built most of the forms in our MS Access database. When we first built the database in Access office 365 we did refreshing of..." /> <meta property="og:description" content="We had a former developer who built most of the forms in our MS Access database. When we first built the database in Access office 365 we did refreshing of tables from our dev version before publishing to production. All was great back then, before the revamping of the managing of linked..." /> <meta property="twitter:description" content="We had a former developer who built most of the forms in our MS Access database. When we first built the database in Access office 365 we did refreshing of tables from our dev version before..." /> <meta property="og:url" content="https://www.tek-tips.com/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/" /> <link rel="canonical" href="https://www.tek-tips.com/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/" /> <meta property="og:site_name" content="Tek-Tips" /> <meta property="og:type" content="website" /> <meta property="og:title" content="Refreshing a linked table (housed on MS SQL Server) now breaks - Microsoft: Access Tables and Relationships" /> <meta property="twitter:title" content="Refreshing a linked table (housed on MS SQL Server) now breaks -..." /> <link rel="preconnect" href="https://fonts.googleapis.com"><link rel="preconnect" href="https://fonts.gstatic.com" crossorigin><link href="https://fonts.googleapis.com/css2?family=Poppins:wght@400;700&display=swap" rel="stylesheet"> <link rel="preload" href="/styles/fonts/fa/fa-light-300.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="preload" href="/styles/fonts/fa/fa-solid-900.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="preload" href="/styles/fonts/fa/fa-brands-400.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="stylesheet" href="/css.php?css=public%3Anormalize.css%2Cpublic%3Afa.css%2Cpublic%3Acore.less%2Cpublic%3Aapp.less&s=3&l=1&d=1731063743&k=0e1337d98c8845c72b8d3c46d22feb00bc113906" /> <link rel="stylesheet" href="/css.php?css=public%3Amessage.less%2Cpublic%3Anotices.less%2Cpublic%3Ashare_controls.less%2Cpublic%3Asnog_groups.less%2Cpublic%3Astructured_list.less%2Cpublic%3AsvESE_autocomplete.less%2Cpublic%3Axb.less%2Cpublic%3Axb_search.less%2Cpublic%3Axb_sidebar_login.less%2Cpublic%3Axb_welcome.less%2Cpublic%3Axc_soft_attachment.less%2Cpublic%3Axc_votes_button.less%2Cpublic%3Aextra.less&s=3&l=1&d=1731063743&k=d475410cac2c3d547917cd175bdc60a67bdface3" /> <script src="/js/xf/preamble.min.js?_v=e65b7ca0"></script> </head> <body data-template="thread_view_type_question">  <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-MMC9PJ9" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>   <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-TZQ8TVZR" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  <div class="p-pageWrapper" id="top"> <div class="p-pageWrapper--helper"></div> <div class="xb-page-wrapper xb-canvas-menuActive"> <div class="xb-page-wrapper--helper"></div> <header class="p-header" id="header"> <div class="p-header-inner"> <div class="p-header-content"> <div class="p-header-logo p-header-logo--image"> <a href="https://www.tek-tips.com"> <img src="/styles/nova/tek-tips/header-logo.png" srcset="" alt="Tek-Tips" width="" height="" /> </a> </div> <div class="xb-searchWrapper" id="xb-searchWrapper" tabindex="0"> <form action="/search/search" id="xbSearch" data-xf-init="quick-search" data-autocomplete-filter="null" data-autocomplete-filter="null" class="xb-search" method="post" data-no-auto-focus="true"> <input type="text" class="input" name="keywords" placeholder="Search…" aria-label="Search" /> <div class="menu menu--structural menu--search" aria-hidden="true"> <div class="menu-content"> <div class="menu-row"> <select name="constraints" class="js-quickSearch-constraint input" aria-label="Search within"> <option value="">Everywhere</option> <option value="{"search_type":"post"}">Threads</option> <option value="{"search_type":"post","c":{"nodes":[700],"child_nodes":1}}">This forum</option> <option value="{"search_type":"post","c":{"thread":1807066}}">This thread</option> </select> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[container_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles and first posts only</span></label> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[title_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles only</span></label> </div> <div class="menu-row"> <div class="inputGroup"> <span class="inputGroup-text" id="ctrl_search_menu_by_member">By:</span> <input type="text" class="input" name="c[users]" data-xf-init="auto-complete" placeholder="Member" aria-labelledby="ctrl_search_menu_by_member" /> </div> </div> <div class="menu-footer"> <span class="menu-footer-controls"> <button type="submit" class="button--primary button button--icon button--icon--search"><span class="button-text">Search</span></button> <a href="/search/" class="button"><span class="button-text">Advanced search…</span></a> </span> </div> <input type="hidden" name="_xfToken" value="1732703716,d82100fcac964718dda3931694b416f9" /> </div> </div> </form> </div> </div> </div> </header> <div class="xb-content-wrapper"> <div class="navigation-helper"></div> <div class="p-navSticky p-navSticky--primary" data-xf-init="sticky-header"> <div class="p-nav--wrapper"> <nav class="p-nav"> <div class="p-nav-inner"> <button type="button" class="button--plain p-nav-menuTrigger button" data-xf-click="off-canvas" data-menu=".js-headerOffCanvasMenu" tabindex="0" aria-label="Menu"><span class="button-text"> <i aria-hidden="true"></i> </span></button> <div class="p-nav-smallLogo"> <a href="https://www.tek-tips.com"> <img src="/styles/nova/tek-tips/header-logo.png" srcset="" alt="Tek-Tips" width="" height="" /> </a> </div> <div class="p-nav-scroller hScroller" data-xf-init="h-scroller" data-auto-scroll=".p-navEl.is-selected"> <div class="hScroller-scroll"> <ul class="p-nav-list js-offCanvasNavSource"> <li class="navhome"> <div class="p-navEl " > <a href="https://www.tek-tips.com" class="p-navEl-link " data-xf-key="1" data-nav-id="home">Home</a> </div> </li> <li class="navforums"> <div class="p-navEl is-selected" data-has-children="true"> <a href="/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="forums">Forums</a> <a data-xf-key="2" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/whats-new/posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="newPosts">New posts</a> <a href="/search/?type=post" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="searchForums">Search forums</a> <a href="/forums/microsoft-access-tables-and-relationships.700/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="0">Forum</a> <a href="/forums/700/faqs/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy faqLink" data-nav-id="1">FAQs</a> <a href="/forums/700/links/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="2">Links</a> <a href="/forums/700/mvps/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy mvpLink" data-nav-id="3">MVPs</a> </div> </div> </div> </li> <li class="navwhatsNew"> <div class="p-navEl " data-has-children="true"> <a href="/whats-new/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="whatsNew">What's new</a> <a data-xf-key="3" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/whats-new/posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="whatsNewPosts">New posts</a> <a href="/whats-new/profile-posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="whatsNewProfilePosts">New profile posts</a> <a href="/whats-new/latest-activity" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="latestActivity">Latest activity</a> </div> </div> </div> </li> <li class="navmembers"> <div class="p-navEl " data-has-children="true"> <a href="/members/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="members">Members</a> <a data-xf-key="4" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/online/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="currentVisitors">Current visitors</a> <a href="/whats-new/profile-posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="newProfilePosts">New profile posts</a> <a href="/search/?type=profile_post" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="searchProfilePosts">Search profile posts</a> </div> </div> </div> </li> </ul> </div> </div> <div class="p-nav-opposite"> <div class="p-navgroup p-account p-navgroup--guest"> <a href="/login/" class="p-navgroup-link p-navgroup-link--textual p-navgroup-link--logIn" data-xf-click="overlay" data-follow-redirects="on"> <span class="p-navgroup-linkText">Log in</span> </a> <a href="/register/" class="p-navgroup-link p-navgroup-link--textual p-navgroup-link--register" data-xf-click="overlay" data-follow-redirects="on"> <span class="p-navgroup-linkText">Register</span> </a> </div> <div class="p-navgroup p-discovery"> <a href="/whats-new/" class="p-navgroup-link p-navgroup-link--iconic p-navgroup-link--whatsnew" aria-label="What's new" title="What's new"> <i aria-hidden="true"></i> <span class="p-navgroup-linkText">What's new</span> </a> <a href="/search/" class="p-navgroup-link p-navgroup-link--iconic p-navgroup-link--search" data-xf-click="menu" data-xf-key="/" aria-label="Search" aria-expanded="false" aria-haspopup="true" title="Search"> <i aria-hidden="true"></i> <span class="p-navgroup-linkText">Search</span> </a> <div class="menu menu--structural menu--wide" data-menu="menu" aria-hidden="true"> <form action="/search/search" method="post" class="menu-content" data-xf-init="quick-search" data-autocomplete-filter="["post"]"> <h3 class="menu-header">Search</h3> <div class="menu-row"> <div class="inputGroup inputGroup--joined"> <input type="text" class="input" name="keywords" placeholder="Search…" aria-label="Search" data-menu-autofocus="true" /> <select name="constraints" class="js-quickSearch-constraint input" aria-label="Search within"> <option value="">Everywhere</option> <option value="{"search_type":"post"}">Threads</option> <option value="{"search_type":"post","c":{"nodes":[700],"child_nodes":1}}">This forum</option> <option value="{"search_type":"post","c":{"thread":1807066}}" data-suggest-optout="1">This thread</option> </select> </div> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[container_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles and first posts only</span></label> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[title_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles only</span></label> </div> <div class="menu-row"> <div class="inputGroup"> <span class="inputGroup-text" id="ctrl_search_menu_by_member">By:</span> <input type="text" class="input" name="c[users]" data-xf-init="auto-complete" placeholder="Member" aria-labelledby="ctrl_search_menu_by_member" /> </div> </div> <div class="menu-footer"> <span class="menu-footer-controls"> <button type="submit" class="button--primary button button--icon button--icon--search"><span class="button-text">Search</span></button> <a href="/search/" class="button"><span class="button-text">Advanced search…</span></a> </span> </div> <input type="hidden" name="_xfToken" value="1732703716,d82100fcac964718dda3931694b416f9" /> </form> </div> </div> </div> </div> </nav> </div> </div> <div class="p-sectionLinks--wrapper"> <div class="p-sectionLinks"> <div class="p-sectionLinks-inner"> <div class="hScroller" data-xf-init="h-scroller"> <div class="hScroller-scroll"> <ul class="p-sectionLinks-list"> <li> <div class="p-navEl " > <a href="/whats-new/posts/" class="p-navEl-link " data-xf-key="alt+1" data-nav-id="newPosts">New posts</a> </div> </li> <li> <div class="p-navEl " > <a href="/search/?type=post" class="p-navEl-link " data-xf-key="alt+2" data-nav-id="searchForums">Search forums</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/microsoft-access-tables-and-relationships.700/" class="p-navEl-link " data-xf-key="alt+3" data-nav-id="0">Forum</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/faqs/" class="p-navEl-link faqLink" data-xf-key="alt+4" data-nav-id="1">FAQs</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/links/" class="p-navEl-link " data-xf-key="alt+5" data-nav-id="2">Links</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/mvps/" class="p-navEl-link mvpLink" data-xf-key="alt+6" data-nav-id="3">MVPs</a> </div> </li> </ul> </div> </div> <div class="p-sectionLinks-right"> </div> </div> </div> </div> <div class="offCanvasMenu offCanvasMenu--nav js-headerOffCanvasMenu" data-menu="menu" aria-hidden="true" data-ocm-builder="navigation"> <div class="offCanvasMenu-backdrop" data-menu-close="true"></div> <div class="offCanvasMenu-content"> <div class="offCanvasMenu-content--inner"> <div class="offCanvasMenu-header"> Menu <a class="offCanvasMenu-closer" data-menu-close="true" role="button" tabindex="0" aria-label="Close"></a> </div> <div class="p-offCanvasRegisterLink"> <div class="offCanvasMenu-linkHolder"> <a href="/login/" class="offCanvasMenu-link" data-xf-click="overlay" data-menu-close="true"> Log in </a> </div> <hr class="offCanvasMenu-separator" /> <div class="offCanvasMenu-linkHolder"> <a href="/register/" class="offCanvasMenu-link" data-xf-click="overlay" data-menu-close="true"> Register </a> </div> <hr class="offCanvasMenu-separator" /> </div> <div class="offCanvasMenu-subHeader">Navigation</div> <div class="js-offCanvasNavTarget"></div> <div class="offCanvasMenu-installBanner js-installPromptContainer" style="display: none;" data-xf-init="install-prompt"> <div class="offCanvasMenu-installBanner-header">Install the app</div> <button type="button" class="js-installPromptButton button"><span class="button-text">Install</span></button> <template class="js-installTemplateIOS"> <div class="overlay-title">How to install the app on iOS</div> <div class="block-body"> <div class="block-row"> <p> Follow along with the video below to see how to install our site as a web app on your home screen. </p> <p style="text-align: center"> <video src="/styles/default/xenforo/add_to_home.mp4" width="280" height="480" autoplay loop muted playsinline></video> </p> <p> <small><strong>Note:</strong> This feature may not be available in some browsers.</small> </p> </div> </div> </template> </div> <div class="offCanvasMenu-subHeader">More options</div> <div class="offCanvasMenu-linkHolder"> <a href="/misc/contact" class="offCanvasMenu-link" data-menu-close="true" data-nav-id="contactUs" data-xf-click="overlay">Contact us</a> </div> <div class="offCanvasMenu-linkHolder"> <a class="offCanvasMenu-link" data-menu-close="true" data-nav-id="closeMenu" role="button" tabindex="0" aria-label="Close">Close Menu</a> </div> </div> </div> </div> <div class="p-body"> <div class="p-body-inner"> <div class="xb-welcome-notice"> <div class="xb-welcome-notice--mask"> <div class="xb-welcome-notice--inner"> <div class="xb-welcome-notice--title"> <h3>Tek-Tips is the largest IT community on the Internet today!</h3> <h4>Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!</h4> </div> <div class="xb-welcome-notice--buttons"> <a href="/register/" class="button" data-xf-click="overlay" data-follow-redirects="on"><span class="button-text">Register</span></a> <a href="/login/" class="button--cta button" rel="nofollow" data-xf-click="overlay" data-menu-close="true"> <span class="button-text">Log in</span> </a> </div> </div> </div> </div>  <ul class="notices notices--block js-notices" data-xf-init="notices" data-type="block" data-scroll-interval="6"> <li class="notice js-notice notice--light" data-notice-id="15" data-delay-duration="0" data-display-duration="0" data-auto-dismiss="" data-visibility=""> <div class="notice-content"> <b>Congratulations <span><a href="/members/mike-lewis.388080/">Mike Lewis</a></span></b> on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go! </div> </li> </ul> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread1'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread1'); }); </script> </div> </div> </div><div> <div class="p-breadcrumbs--parent "> <ul class="p-breadcrumbs " itemscope itemtype="https://schema.org/BreadcrumbList"> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="https://www.tek-tips.com" itemprop="item"> <span itemprop="name">Home</span> </a> <meta itemprop="position" content="1" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/" itemprop="item"> <span itemprop="name">Forums</span> </a> <meta itemprop="position" content="2" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/#software.1001" itemprop="item"> <span itemprop="name">Software</span> </a> <meta itemprop="position" content="3" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/programmers.1004/" itemprop="item"> <span itemprop="name">Programmers</span> </a> <meta itemprop="position" content="4" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/dbms-packages.10027/" itemprop="item"> <span itemprop="name">DBMS Packages</span> </a> <meta itemprop="position" content="5" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/forums/microsoft-access-tables-and-relationships.700/" itemprop="item"> <span itemprop="name">Microsoft: Access Tables and Relationships</span> </a> <meta itemprop="position" content="6" /> </li> </ul> </div> <noscript class="js-jsWarning"><div class="blockMessage blockMessage--important blockMessage--iconic u-noJsOnly">JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.</div></noscript> <div class="blockMessage blockMessage--important blockMessage--iconic js-browserWarning" style="display: none">You are using an out of date browser. It may not display this or other websites correctly.<br />You should upgrade or use an <a href="https://www.google.com/chrome/" target="_blank" rel="noopener">alternative browser</a>.</div>  <div class="p-body-header"> <div class="p-title "> <h1 class="p-title-value">Refreshing a linked table (housed on MS SQL Server) now breaks </h1> </div> <div class="p-description"> <ul class="listInline listInline--bullet"> <li> <i class="fa--xf fal fa-user" aria-hidden="true" title="Thread starter"></i> <span class="u-srOnly">Thread starter</span> <a href="/members/03explorer.1060185/" class="username u-concealed" dir="auto" data-user-id="1060185" data-xf-init="member-tooltip">03Explorer</a> </li> <li> <i class="fa--xf fal fa-clock" aria-hidden="true" title="Start date"></i> <span class="u-srOnly">Start date</span> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/" class="u-concealed"><time class="u-dt" dir="auto" datetime="2020-11-13T22:22:57+0000" data-time="1605306177" data-date-string="Nov 13, 2020" data-time-string="10:22 PM" title="Nov 13, 2020 at 10:22 PM">Nov 13, 2020</time></a> </li> </ul> </div> </div>  <div class="p-body-main p-body-main--withSidebar "> <div class="p-body-contentCol"></div> <div class="p-body-sidebarCol"></div> <div class="p-body-content">  <div id='div-gpt-tektips_wallpaper'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_wallpaper'); }); </script> </div> <div class="p-body-pageContent"> <div class="block block--messages " data-xf-init="lightbox select-to-quote" data-message-selector=".js-post" data-lb-id="thread-1807066"> <div class="block-outer"> <dl class="blockStatus"> <dt>Status</dt> <dd class="blockStatus-message blockStatus-message--locked"> Not open for further replies. </dd> </dl> </div> <div class="block-outer"></div> <div class="block-outer js-threadStatusField"></div> <div class="block-container"> <div class="block-body"> <article class="message message--post js-post js-inlineModContainer " data-author="03Explorer" data-content="post-7484128" id="js-post-7484128" > <span class="u-anchorTarget" id="post-7484128"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7484128" rel="nofollow" > <time class="u-dt" dir="auto" datetime="2020-11-13T22:22:57+0000" data-time="1605306177" data-date-string="Nov 13, 2020" data-time-string="10:22 PM" title="Nov 13, 2020 at 10:22 PM">Nov 13, 2020</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7484128" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7484128/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7484128" rel="nofollow"> #1 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" > <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/03explorer.1060185/" class="avatar avatar--s" data-user-id="1060185" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="03Explorer" class="avatar-u1060185-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/03explorer.1060185/" class="username " dir="auto" data-user-id="1060185" data-xf-init="member-tooltip">03Explorer</a></h4> <h5 class="userTitle message-userTitle" dir="auto">Technical User</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Sep 13, 2005</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>304</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7484128" data-lb-caption-desc="03Explorer · Nov 13, 2020 at 10:22 PM"> <article class="message-body js-selectToQuote"> <div > <div class="bbWrapper">We had a former developer who built most of the forms in our MS Access database. When we first built the database in Access office 365 we did refreshing of tables from our dev version before publishing to production. All was great back then, before the revamping of the managing of linked tables. Since the rework on linked table manager we can no longer just refresh a table. It now asks what we want to use for Unique Record Identifiers. I do not know what the former developer used for those, but from my research I've been doing fine with the cancel at that screen. We manage the record identifiers at the SQL server side. WELLLLLLLL... now I have ONE table that works great from an archive version, but for only one table I do a refresh & the cancel at Unique question give me an error within a form. The error is either something got corrupted or there was a Unique mapping. How can I find out what the Unique identifier options were selected (if they were used) or is it a corrupt (something)??<br /> <br /> The error I now get is Run-time error '2105': You can't go to the specified record.<br /> <br /> I am at a loss how do deal with this.<br /> <br /> Rob</div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> </div> </article> </div> </div> </div> <div class="block block--messages" data-xf-init="" data-type="post" data-href="/inline-mod/" data-search-target="*"> <span class="u-anchorTarget" id="posts"></span> <div class="block-outer"><div class="block-outer-opposite"> <div class="tabs tabs--standalone tabs--standalone--small tabs--standalone--inline"> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/" class="tabs-tab is-active" rel="nofollow"> Sort by date </a> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/?order=vote_score" class="tabs-tab " rel="nofollow"> Sort by votes </a> </div> </div></div> <div class="block-container lbContainer" data-xf-init="lightbox select-to-quote" data-message-selector=".js-post" data-lb-id="thread-1807066" data-lb-universal="0"> <div class="block-body js-replyNewMessageContainer"> <article class="message message--post js-post js-inlineModContainer " data-author="03Explorer" data-content="post-7485272" id="js-post-7485272" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7485272/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/" /> <span class="u-anchorTarget" id="post-7485272"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7485272" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2020-11-30T17:34:27+0000" data-time="1606757667" data-date-string="Nov 30, 2020" data-time-string="5:34 PM" title="Nov 30, 2020 at 5:34 PM" itemprop="datePublished">Nov 30, 2020</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li class="tag-threadStarter"><span class="message-newIndicator message-threadStarter">Thread starter</span></li> <li> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7485272" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7485272/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7485272" rel="nofollow"> #2 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/03explorer.1060185/"> <meta itemprop="url" content="https://www.tek-tips.com/members/03explorer.1060185/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/03explorer.1060185/" class="avatar avatar--s" data-user-id="1060185" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="03Explorer" class="avatar-u1060185-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/03explorer.1060185/" class="username " dir="auto" data-user-id="1060185" data-xf-init="member-tooltip"><span itemprop="name">03Explorer</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Technical User</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Sep 13, 2005</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>304</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7485272" data-lb-caption-desc="03Explorer · Nov 30, 2020 at 5:34 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">*thinking* wonder why this thread is not getting any attention.</div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7485272"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="lameid" data-content="post-7485487" id="js-post-7485487" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7485487/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/" /> <span class="u-anchorTarget" id="post-7485487"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7485487" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2020-12-02T14:58:34+0000" data-time="1606921114" data-date-string="Dec 2, 2020" data-time-string="2:58 PM" title="Dec 2, 2020 at 2:58 PM" itemprop="datePublished">Dec 2, 2020</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7485487" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7485487/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7485487" rel="nofollow"> #3 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/lameid.57524/"> <meta itemprop="url" content="https://www.tek-tips.com/members/lameid.57524/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/lameid.57524/" class="avatar avatar--s" data-user-id="57524" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="lameid" class="avatar-u57524-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/lameid.57524/" class="username " dir="auto" data-user-id="57524" data-xf-init="member-tooltip"><span itemprop="name">lameid</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Programmer</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Jan 31, 2001</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>4,209</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7485487" data-lb-caption-desc="lameid · Dec 2, 2020 at 2:58 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">What access does behind the scenes is create an index representing the unique fields when you do that.<br /> I would look into inspecting the index on the linked table. I've not had to do this myself.<br /> I think many of us don't visit these threads often now... I have my own problem in other topics about corruption and hoping someone else has hit the pain...</div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7485487"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="dhookom" data-content="post-7485498" id="js-post-7485498" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7485498/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/" /> <span class="u-anchorTarget" id="post-7485498"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7485498" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2020-12-02T15:23:21+0000" data-time="1606922601" data-date-string="Dec 2, 2020" data-time-string="3:23 PM" title="Dec 2, 2020 at 3:23 PM" itemprop="datePublished">Dec 2, 2020</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7485498" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7485498/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/post-7485498" rel="nofollow"> #4 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/dhookom.529593/"> <meta itemprop="url" content="https://www.tek-tips.com/members/dhookom.529593/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/dhookom.529593/" class="avatar avatar--s" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" srcset="/data/avatars/m/529/529593.jpg?1723729896 2x" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip"><span itemprop="name">dhookom</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Programmer</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Jun 24, 2003</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>22,510</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7485498" data-lb-caption-desc="dhookom · Dec 2, 2020 at 3:23 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">When you link to the SQL Server tables I assume you are being asked to identify the unique columns/fields.<br /> Are there primary keys or unique indexes on the SQL Server tables?<br /> Every table should have a primary key. If not, I would add one on the SQL server table.<br /> <br /> You can also use a DDL query on the Access side to create a unique index. Of course the chosen field(s) must be unique.<br /> <br /> <span style="color: Blue"><b><i>Duane<br /> Minnesota<br /> <a href="http://www.access.hookom.net/" target="_blank" class="link link--external" rel="nofollow ugc noopener">Hook'D on Access</a><br /> MS Access MVP 2001-2016<br /> </i></b></span></div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7485498"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> </div> </div> <div class="block-outer block-outer--after"> <dl class="blockStatus"> <dt>Status</dt> <dd class="blockStatus-message blockStatus-message--locked"> Not open for further replies. </dd> </dl> </div> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread3'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread3'); }); </script> </div></div></div> <div class="block" data-widget-id="11" data-widget-key="xfes_thread_view_below_quick_reply_similar_threads" data-widget-definition="xfes_similar_threads"> <div class="block-container"> <h3 class="block-header">Similar threads</h3> <div class="block-body"> <div class="structItemContainer"> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1820070" data-author="raywood1"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/raywood1.1102335/" class="avatar avatar--s" data-user-id="1102335" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="raywood1" class="avatar-u1102335-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/reducing-a-massive-linked-table.1820070/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/reducing-a-massive-linked-table.1820070/preview">Reducing a Massive Linked Table</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/raywood1.1102335/" class="username " dir="auto" data-user-id="1102335" data-xf-init="member-tooltip">raywood1</a></li> <li class="structItem-startDate"><a href="/threads/reducing-a-massive-linked-table.1820070/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2023-01-11T04:10:00+0000" data-time="1673410200" data-date-string="Jan 11, 2023" data-time-string="4:10 AM" title="Jan 11, 2023 at 4:10 AM">Jan 11, 2023</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>4</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>296</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/reducing-a-massive-linked-table.1820070/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2023-01-14T22:49:00+0000" data-time="1673736540" data-date-string="Jan 14, 2023" data-time-string="10:49 PM" title="Jan 14, 2023 at 10:49 PM">Jan 14, 2023</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1808404" data-author="Anthony343242"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/anthony343242.1697540/" class="avatar avatar--s" data-user-id="1697540" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="Anthony343242" class="avatar-u1697540-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/ms-access-union-all-with-attachment-data-type.1808404/preview">MS ACCESS UNION ALL with Attachment data type </a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/anthony343242.1697540/" class="username " dir="auto" data-user-id="1697540" data-xf-init="member-tooltip">Anthony343242</a></li> <li class="structItem-startDate"><a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2021-02-04T00:06:03+0000" data-time="1612397163" data-date-string="Feb 4, 2021" data-time-string="12:06 AM" title="Feb 4, 2021 at 12:06 AM">Feb 4, 2021</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> <span class="structItem-pageJump"> <a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/page-2">2</a> </span> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>29</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>1K</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2021-02-08T21:28:50+0000" data-time="1612819730" data-date-string="Feb 8, 2021" data-time-string="9:28 PM" title="Feb 8, 2021 at 9:28 PM">Feb 8, 2021</time></a> <div class="structItem-minor"> <a href="/members/anthony343242.1697540/" class="username " dir="auto" data-user-id="1697540" data-xf-init="member-tooltip">Anthony343242</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/anthony343242.1697540/" class="avatar avatar--xxs" data-user-id="1697540" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="Anthony343242" class="avatar-u1697540-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1813269" data-author="JayRo71"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/jayro71.1692646/" class="avatar avatar--s" data-user-id="1692646" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="JayRo71" class="avatar-u1692646-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/importing-only-unique-records-from-excel-tables.1813269/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/importing-only-unique-records-from-excel-tables.1813269/preview">Importing only unique records from excel tables </a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/jayro71.1692646/" class="username " dir="auto" data-user-id="1692646" data-xf-init="member-tooltip">JayRo71</a></li> <li class="structItem-startDate"><a href="/threads/importing-only-unique-records-from-excel-tables.1813269/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2022-01-06T15:46:59+0000" data-time="1641484019" data-date-string="Jan 6, 2022" data-time-string="3:46 PM" title="Jan 6, 2022 at 3:46 PM">Jan 6, 2022</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>10</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>386</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/importing-only-unique-records-from-excel-tables.1813269/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2022-01-11T19:15:36+0000" data-time="1641928536" data-date-string="Jan 11, 2022" data-time-string="7:15 PM" title="Jan 11, 2022 at 7:15 PM">Jan 11, 2022</time></a> <div class="structItem-minor"> <a href="/members/skipvought.166621/" class="username " dir="auto" data-user-id="166621" data-xf-init="member-tooltip">SkipVought</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/skipvought.166621/" class="avatar avatar--xxs avatar--default avatar--default--dynamic" data-user-id="166621" data-xf-init="member-tooltip" style="background-color: #cc3352; color: #f0c2cb"> <span class="avatar-u166621-s" role="img" aria-label="SkipVought">S</span> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1796260" data-author="BugZap13"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/bugzap13.1653487/" class="avatar avatar--s" data-user-id="1653487" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="BugZap13" class="avatar-u1653487-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/preview">How to extract Access table schema with decimal places on numeric fields?</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/bugzap13.1653487/" class="username " dir="auto" data-user-id="1653487" data-xf-init="member-tooltip">BugZap13</a></li> <li class="structItem-startDate"><a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2019-08-05T10:00:43+0100" data-time="1564995643" data-date-string="Aug 5, 2019" data-time-string="10:00 AM" title="Aug 5, 2019 at 10:00 AM">Aug 5, 2019</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>2</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>688</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2019-08-05T12:04:40+0100" data-time="1565003080" data-date-string="Aug 5, 2019" data-time-string="12:04 PM" title="Aug 5, 2019 at 12:04 PM">Aug 5, 2019</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1807944" data-author="ameedoo3000"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/ameedoo3000.1675658/" class="avatar avatar--s" data-user-id="1675658" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="ameedoo3000" class="avatar-u1675658-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/send-a-message-to-an-email.1807944/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/send-a-message-to-an-email.1807944/preview">Send a message to an email</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/ameedoo3000.1675658/" class="username " dir="auto" data-user-id="1675658" data-xf-init="member-tooltip">ameedoo3000</a></li> <li class="structItem-startDate"><a href="/threads/send-a-message-to-an-email.1807944/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2021-01-11T12:31:51+0000" data-time="1610368311" data-date-string="Jan 11, 2021" data-time-string="12:31 PM" title="Jan 11, 2021 at 12:31 PM">Jan 11, 2021</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>2</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>627</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/send-a-message-to-an-email.1807944/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2021-01-11T13:25:28+0000" data-time="1610371528" data-date-string="Jan 11, 2021" data-time-string="1:25 PM" title="Jan 11, 2021 at 1:25 PM">Jan 11, 2021</time></a> <div class="structItem-minor"> <a href="/members/ameedoo3000.1675658/" class="username " dir="auto" data-user-id="1675658" data-xf-init="member-tooltip">ameedoo3000</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/ameedoo3000.1675658/" class="avatar avatar--xxs" data-user-id="1675658" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="ameedoo3000" class="avatar-u1675658-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> </div> </div> </div> </div> <div class="blockMessage blockMessage--none"> <div class="shareButtons shareButtons--iconic" data-xf-init="share-buttons" data-page-url="" data-page-title="" data-page-desc="" data-page-image=""> <span class="shareButtons-label">Share:</span> <div class="shareButtons-buttons"> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--facebook" data-href="https://www.facebook.com/sharer.php?u={url}"> <i aria-hidden="true"></i> <span>Facebook</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--twitter" data-href="https://twitter.com/intent/tweet?url={url}&text={title}"> <svg xmlns="http://www.w3.org/2000/svg" height="1em" viewBox="0 0 512 512" class=""><path d="M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z"/></svg> <span>X (Twitter)</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--reddit" data-href="https://reddit.com/submit?url={url}&title={title}"> <i aria-hidden="true"></i> <span>Reddit</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--pinterest" data-href="https://pinterest.com/pin/create/bookmarklet/?url={url}&description={title}&media={image}"> <i aria-hidden="true"></i> <span>Pinterest</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--tumblr" data-href="https://www.tumblr.com/widgets/share/tool?canonicalUrl={url}&title={title}"> <i aria-hidden="true"></i> <span>Tumblr</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--whatsApp" data-href="https://api.whatsapp.com/send?text={title} {url}"> <i aria-hidden="true"></i> <span>WhatsApp</span> </a> <a class="shareButtons-button shareButtons-button--email" data-href="mailto:?subject={title}&body={url}"> <i aria-hidden="true"></i> <span>Email</span> </a> <a class="shareButtons-button shareButtons-button--share is-hidden" data-xf-init="web-share" data-title="" data-text="" data-url="" data-hide=".shareButtons-button:not(.shareButtons-button--share)"> <i aria-hidden="true"></i> <span>Share</span> </a> <a class="shareButtons-button shareButtons-button--link is-hidden" data-clipboard="{url}"> <i aria-hidden="true"></i> <span>Link</span> </a> </div> </div> </div> </div> </div> <div class="p-sidebarWrapper"> <div class="p-body-sidebar"> <div class="block block--login"> <form action="/login/login" method="post" class="" > <input type="hidden" name="_xfToken" value="1732703716,d82100fcac964718dda3931694b416f9" /> <div class="block-container"> <h3 class="block-minorHeader"> Log in </h3> <div class="block-body"> <div class="block-row"> <dl class="formRow formRow--input"> <dt> <div class="formRow-labelWrapper"> <label class="formRow-label" for="_xfUid-1-1732703716">Your name or email address</label></div> </dt> <dd> <input type="text" class="input" name="login" autocomplete="username" id="_xfUid-1-1732703716" /> </dd> </dl> <dl class="formRow formRow--input"> <dt> <div class="formRow-labelWrapper"> <label class="formRow-label" for="_xfUid-2-1732703716">Password</label></div> </dt> <dd> <input type="password" class="input" name="password" autocomplete="current-password" id="_xfUid-2-1732703716" /> <a href="/lost-password/" data-xf-click="overlay">Forgot your password?</a> </dd> </dl> <dl class="formRow"> <dt> <div class="formRow-labelWrapper"></div> </dt> <dd> <ul class="inputChoices"> <li class="inputChoices-choice"><label class="iconic"><input type="checkbox" name="remember" value="1" checked="checked" /><i aria-hidden="true"></i><span class="iconic-label">Stay logged in</span></label></li> </ul> </dd> </dl> <dl class="formRow formSubmitRow"> <dt></dt> <dd> <div class="formSubmitRow-main"> <div class="formSubmitRow-bar"></div> <div class="formSubmitRow-controls"><button type="submit" class="button--primary button button--icon button--icon--login"><span class="button-text">Log in</span></button></div> </div> </dd> </dl> <dl class="formRow formRegisterRow"> <dt></dt> <dd>Don't have an account? <a href="/register/" data-xf-click="overlay" data-follow-redirects="on">Register now</a></dd> </dl> </div> </div> </div> </form> </div> <div class="block"> <div class="block-container" data-widget-id="18" data-widget-key="right_search_top" data-widget-definition="html"> <h3 class="block-minorHeader">Part and Inventory Search</h3> <div class="block-body block-row"> <center><div id='div-gpt-tektips_customsearchbox'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_customsearchbox'); }); </script> </div> </center> </div> </div> </div> <div class="block"> <div class="block-container" data-widget-id="13" data-widget-key="right_rail_middle_bottom_ga" data-widget-definition="html"> <h3 class="block-minorHeader">Sponsor</h3> <div class="block-body block-row"> <center> <div id='div-gpt-tektips_sidebar1'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_sidebar1'); }); </script> </div> </center> </div> </div> </div> </div> </div> </div> <div class="p-breadcrumbs--parent p-breadcrumbs--bottom"> <ul class="p-breadcrumbs p-breadcrumbs--bottom" itemscope itemtype="https://schema.org/BreadcrumbList"> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="https://www.tek-tips.com" itemprop="item"> <span itemprop="name">Home</span> </a> <meta itemprop="position" content="1" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/" itemprop="item"> <span itemprop="name">Forums</span> </a> <meta itemprop="position" content="2" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/#software.1001" itemprop="item"> <span itemprop="name">Software</span> </a> <meta itemprop="position" content="3" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/programmers.1004/" itemprop="item"> <span itemprop="name">Programmers</span> </a> <meta itemprop="position" content="4" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/dbms-packages.10027/" itemprop="item"> <span itemprop="name">DBMS Packages</span> </a> <meta itemprop="position" content="5" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/forums/microsoft-access-tables-and-relationships.700/" itemprop="item"> <span itemprop="name">Microsoft: Access Tables and Relationships</span> </a> <meta itemprop="position" content="6" /> </li> </ul> </div> </div> </div> </div>  <footer class="p-footer" id="footer"> <div class="p-footer--container footer-stretched"> <div class="p-footer-default"> <div class="p-footer-inner"> <div class="p-footer-row"> <div class="p-footer-row-main"> <ul class="p-footer-linkList"> <li class="p-linkList-changeStyle"><a href="/misc/style" data-xf-click="overlay" data-xf-init="tooltip" title="Style: TekTips" rel="nofollow"> Style chooser </a></li> <li class="p-linkList-changeWidth"><a class="pageWidthToggle xb-toggle-default" role="button" tabindex="0" data-xf-click="toggle" data-target="html" data-active-class="xb-toggle-default" data-xf-init="toggle-storage" data-storage-type="cookie" data-storage-expiry="31556926" data-storage-key="_xb-width"> Change width </a></li> </ul> </div> <div class="p-footer-row-opposite"> <ul class="p-footer-linkList"> <li><a href="/misc/contact" data-xf-click="overlay">Contact us</a></li> <li><a href="/help/terms/">Terms and rules</a></li> <li><a href="/help/privacy-policy/">Privacy policy</a></li> <li><a href="/help/">Help</a></li> <li><a href="https://www.tek-tips.com">Home</a></li> <li><a href="/forums/-/index.rss" target="_blank" class="p-footer-rssLink" title="RSS"><span aria-hidden="true"><i class="fa--xf fal fa-rss" aria-hidden="true"></i><span class="u-srOnly">RSS</span></span></a></li> </ul> </div> </div> </div> </div> <div class="p-footer-copyright"> <div class="p-footer-inner"> <div class="p-footer-copyright--flex"> <div class="copyright-left"> Copyright © <script type="text/javascript">d = new Date();y = d.getFullYear();document.write(y);</script> WTWH Media, LLC. All Rights Reserved. </div> </div> </div> </div> </div> </footer> </div>  </div>  <div class="u-bottomFixer js-bottomFixTarget"> <ul class="notices notices--bottom_fixer js-notices" data-xf-init="notices" data-type="bottom_fixer" data-scroll-interval="6"> <li class="notice js-notice notice--primary notice--cookie" data-notice-id="-1" data-delay-duration="0" data-display-duration="0" data-auto-dismiss="0" data-visibility=""> <div class="notice-content"> <div class="u-alignCenter"> This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.<br /> By continuing to use this site, you are consenting to our use of cookies. </div> <div class="u-inputSpacer u-alignCenter"> <a href="/account/dismiss-notice" class="js-noticeDismiss button--notice button button--icon button--icon--confirm"><span class="button-text">Accept</span></a> <a href="/help/cookies" class="button--notice button"><span class="button-text">Learn more…</span></a> </div> </div> </li> </ul> </div> <div class="u-navButtons js-navButtons" data-trigger-type="up"> <a href="javascript:" class="button--scroll button"><span class="button-text"><i class="fa--xf fal fa-arrow-left" aria-hidden="true"></i><span class="u-srOnly">Back</span></span></a> </div> <div class="u-scrollButtons js-scrollButtons" data-trigger-type="up"> <a href="#top" class="button--scroll button" data-xf-click="scroll-to"><span class="button-text"><i class="fa--xf fal fa-arrow-up" aria-hidden="true"></i><span class="u-srOnly">Top</span></span></a> </div> <script src="/js/vendor/jquery/jquery-3.5.1.min.js?_v=e65b7ca0"></script> <script src="/js/vendor/vendor-compiled.js?_v=e65b7ca0"></script> <script src="/js/xf/core-compiled.js?_v=e65b7ca0"></script> <script src="/js/sv/ese/xf/structure.min.js?_v=e65b7ca0"></script> <script src="/js/xf/notice.min.js?_v=e65b7ca0"></script> <script> $(".xb-searchWrapper").on("click", function(event) { $(".xb-searchWrapper").addClass("is-active"); event.stopPropagation(); }); $(".xb-searchWrapper").on("click", function(event) { event.stopPropagation(); }); $(document).on("click", function(event) { $(".xb-searchWrapper").removeClass("is-active"); }); </script> <script> jQuery.extend(true, XF.config, { // userId: 0, enablePush: false, pushAppServerKey: '', url: { fullBase: 'https://www.tek-tips.com/', basePath: '/', css: '/css.php?css=__SENTINEL__&s=3&l=1&d=1731063743', keepAlive: '/login/keep-alive' }, cookie: { path: '/', domain: '', prefix: 'xf_', secure: true, consentMode: 'simple', consented: ["optional","_third_party"] }, cacheKey: 'cf136c583e6591f869f990ac86545fee', csrf: '1732703716,d82100fcac964718dda3931694b416f9', js: {"\/js\/sv\/ese\/xf\/structure.min.js?_v=e65b7ca0":true,"\/js\/xf\/notice.min.js?_v=e65b7ca0":true}, css: {"public:message.less":true,"public:notices.less":true,"public:share_controls.less":true,"public:snog_groups.less":true,"public:structured_list.less":true,"public:svESE_autocomplete.less":true,"public:xb.less":true,"public:xb_search.less":true,"public:xb_sidebar_login.less":true,"public:xb_welcome.less":true,"public:xc_soft_attachment.less":true,"public:xc_votes_button.less":true,"public:extra.less":true}, time: { now: 1732703716, today: 1732665600, todayDow: 3, tomorrow: 1732752000, yesterday: 1732579200, week: 1732147200 }, borderSizeFeature: '2px', fontAwesomeWeight: 'l', enableRtnProtect: true, enableFormSubmitSticky: true, uploadMaxFilesize: 268435456, allowedVideoExtensions: ["m4v","mov","mp4","mp4v","mpeg","mpg","ogv","webm"], allowedAudioExtensions: ["mp3","opus","ogg","wav"], shortcodeToEmoji: true, visitorCounts: { conversations_unread: '0', alerts_unviewed: '0', total_unread: '0', title_count: true, icon_indicator: true }, jsState: {}, publicMetadataLogoUrl: '', publicPushBadgeUrl: 'https://www.tek-tips.com/styles/default/xenforo/bell.png' }); jQuery.extend(XF.phrases, { // date_x_at_time_y: "{date} at {time}", day_x_at_time_y: "{day} at {time}", yesterday_at_x: "Yesterday at {time}", x_minutes_ago: "{minutes} minutes ago", one_minute_ago: "1 minute ago", a_moment_ago: "A moment ago", today_at_x: "Today at {time}", in_a_moment: "In a moment", in_a_minute: "In a minute", in_x_minutes: "In {minutes} minutes", later_today_at_x: "Later today at {time}", tomorrow_at_x: "Tomorrow at {time}", day0: "Sunday", day1: "Monday", day2: "Tuesday", day3: "Wednesday", day4: "Thursday", day5: "Friday", day6: "Saturday", dayShort0: "Sun", dayShort1: "Mon", dayShort2: "Tue", dayShort3: "Wed", dayShort4: "Thu", dayShort5: "Fri", dayShort6: "Sat", month0: "January", month1: "February", month2: "March", month3: "April", month4: "May", month5: "June", month6: "July", month7: "August", month8: "September", month9: "October", month10: "November", month11: "December", active_user_changed_reload_page: "The active user has changed. Reload the page for the latest version.", server_did_not_respond_in_time_try_again: "The server did not respond in time. Please try again.", oops_we_ran_into_some_problems: "Oops! We ran into some problems.", oops_we_ran_into_some_problems_more_details_console: "Oops! We ran into some problems. Please try again later. More error details may be in the browser console.", file_too_large_to_upload: "The file is too large to be uploaded.", uploaded_file_is_too_large_for_server_to_process: "The uploaded file is too large for the server to process.", files_being_uploaded_are_you_sure: "Files are still being uploaded. Are you sure you want to submit this form?", attach: "Attach files", rich_text_box: "Rich text box", close: "Close", link_copied_to_clipboard: "Link copied to clipboard.", text_copied_to_clipboard: "Text copied to clipboard.", loading: "Loading…", you_have_exceeded_maximum_number_of_selectable_items: "You have exceeded the maximum number of selectable items.", processing: "Processing", 'processing...': "Processing…", showing_x_of_y_items: "Showing {count} of {total} items", showing_all_items: "Showing all items", no_items_to_display: "No items to display", number_button_up: "Increase", number_button_down: "Decrease", push_enable_notification_title: "Push notifications enabled successfully at Tek-Tips", push_enable_notification_body: "Thank you for enabling push notifications!", pull_down_to_refresh: "Pull down to refresh", release_to_refresh: "Release to refresh", refreshing: "Refreshing…" , "svStandardLib_time.day": "{count} day", "svStandardLib_time.days": "{count} days", "svStandardLib_time.hour": "{count} hour", "svStandardLib_time.hours": "{count} hours", "svStandardLib_time.minute": "{count} minutes", "svStandardLib_time.minutes": "{count} minutes", "svStandardLib_time.month": "{count} month", "svStandardLib_time.months": "{count} months", "svStandardLib_time.second": "{count} second", "svStandardLib_time.seconds": "{count} seconds", "svStandardLib_time.week": "time.week", "svStandardLib_time.weeks": "{count} weeks", "svStandardLib_time.year": "{count} year", "svStandardLib_time.years": "{count} years" }); </script> <form style="display:none" hidden="hidden"> <input type="text" name="_xfClientLoadTime" value="" id="_xfClientLoadTime" title="_xfClientLoadTime" tabindex="-1" /> </form>  <script type="application/ld+json"> { "@context": "https://schema.org", "@type": "QAPage", "url": "https://www.tek-tips.com/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/", "mainEntity": { "@type": "Question", "@id": "https://www.tek-tips.com/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/", "name": "Refreshing a linked table (housed on MS SQL Server) now breaks", "datePublished": "2020-11-13T22:22:57+00:00", "url": "https://www.tek-tips.com/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/", "text": "We had a former developer who built most of the forms in our MS Access database. When we first built the database in Access office 365 we did refreshing of tables from our dev version before publishing to production. All was great back then, before the revamping of the managing of linked tables. Since the rework on linked table manager we can no longer just refresh a table. It now asks what we want to use for Unique Record Identifiers. I do not know what the former developer used for those, but from my research I've been doing fine with the cancel at that screen. We manage the record identifiers at the SQL server side. WELLLLLLLL... now I have ONE table that works great from an archive version, but for only one table I do a refresh & the cancel at Unique question give me an error within a form. The error is either something got corrupted or there was a Unique mapping. How can I find out what the Unique identifier options were selected (if they were used) or is it a corrupt (something)??\n\nThe error I now get is Run-time error '2105': You can't go to the specified record.\n\nI am at a loss how do deal with this.\n\nRob", "answerCount": 3, "upvoteCount": 0, "author": { "@type": "Person", "@id": "https://www.tek-tips.com/members/03explorer.1060185/", "name": "03Explorer", "url": "https://www.tek-tips.com/members/03explorer.1060185/" }, "suggestedAnswer": [ { "@type": "Answer", "datePublished": "2020-12-02T15:23:21+00:00", "url": "https://www.tek-tips.com/posts/7485498/", "text": "When you link to the SQL Server tables I assume you are being asked to identify the unique columns/fields.\nAre there primary keys or unique indexes on the SQL Server tables?\nEvery table should have a primary key. If not, I would add one on the SQL server table.\n\nYou can also use a DDL query on the Access side to create a unique index. Of course the chosen field(s) must be unique.\n\nDuane\nMinnesota\nHook'D on Access\nMS Access MVP 2001-2016", "upvoteCount": 0, "author": { "@type": "Person", "@id": "https://www.tek-tips.com/members/dhookom.529593/", "name": "dhookom", "url": "https://www.tek-tips.com/members/dhookom.529593/" } }, { "@type": "Answer", "datePublished": "2020-12-02T14:58:34+00:00", "url": "https://www.tek-tips.com/posts/7485487/", "text": "What access does behind the scenes is create an index representing the unique fields when you do that.\nI would look into inspecting the index on the linked table. I've not had to do this myself.\nI think many of us don't visit these threads often now... I have my own problem in other topics about corruption and hoping someone else has hit the pain...", "upvoteCount": 0, "author": { "@type": "Person", "@id": "https://www.tek-tips.com/members/lameid.57524/", "name": "lameid", "url": "https://www.tek-tips.com/members/lameid.57524/" } }, { "@type": "Answer", "datePublished": "2020-11-30T17:34:27+00:00", "url": "https://www.tek-tips.com/posts/7485272/", "text": "*thinking* wonder why this thread is not getting any attention.", "upvoteCount": 0, "author": { "@type": "Person", "@id": "https://www.tek-tips.com/members/03explorer.1060185/", "name": "03Explorer", "url": "https://www.tek-tips.com/members/03explorer.1060185/" } } ] }, "publisher": { "@type": "Organization", "name": "Tek-Tips", "alternateName": "Tek-Tips Information Technology Professional Forums", "description": "Tek-Tips Forums is an intelligent work forum community for Information Technology professionals.", "url": "https://www.tek-tips.com" } } </script> </body> </html>

CINXE.COM

Refreshing a linked table (housed on MS SQL Server) now breaks - Microsoft: Access Tables and Relationships | Tek-Tips