{"id":860,"date":"2012-08-03T16:23:00","date_gmt":"2012-08-03T08:23:00","guid":{"rendered":"http:\/\/vm-officeblogs.cloudapp.net\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/"},"modified":"2022-07-26T06:13:04","modified_gmt":"2022-07-26T13:13:04","slug":"automatically-relink-microsoft-access-tables","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/","title":{"rendered":"Automatically relink Microsoft Access tables"},"content":{"rendered":"<p><img decoding=\"async\" style=\"border: 0px currentColor; margin-right: 12px; float: left;\" title=\"Relinking Tables in Access\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/53\/0550.SUMMARY_LinkedTables_300x166.jpg\" alt=\"Relinking Tables in Access\" \/>(<i>Guest blogger Patrick Wood, an Access MVP, is the founder of <\/i><i>Gaining Access Technologies<\/i><i>, a software company specializing in working with SQL Azure and Access. He also founded <\/i><i>Microsoft Access and SQL Azure Information Cente<\/i><i>r for developers. For more information, contact <\/i><a href=\"mailto:patwood@gainingaccess.net\">patwood@gainingaccess.net<\/a>)<\/p>\n<p>In this article we will show you how you can call a single procedure using just a little code to automatically relink your back-end tables, even when the database files have been moved to a different folder. The procedure will also relink the tables in multiple back-ends. And best of all, you don&#8217;t have to know much about writing code to make this work.<\/p>\n<p>Automating the relinking of tables just makes good sense. This is especially true if you are distributing your database to others. It can save you a lot of headaches, trouble, travel, and time. You do not have to be physically present, nor do you need to remotely access another computer. Additionally, you do not have to enter the names of your back end database(s) or your linked tables.<\/p>\n<h3>How does it work?<\/h3>\n<p>The code gets important information from the <b>TableDefs<\/b> collection in your front-end. This includes the names of your linked tables and the names of your back-end databases. The code then uses this information along with the existing path of the front-end database to get the string needed to set the <b>TableDef Connect Property<\/b>. The code loops through the <b>TableDefs Collection<\/b> and uses the <b>TableDef RefreshLink Method<\/b> to <b>Refresh<\/b> the links.<\/p>\n<p>Here is what the code will do:<\/p>\n<ul type=\"disc\">\n<li>Relink all linked Access database tables if the back-end and front-end are in the same folder.<\/li>\n<li>Relink tables when the databases are moved to a different folder or a different computer.<\/li>\n<li>Relink tables in multiple back-end Access databases.<\/li>\n<li>Does not require you enter or store database or table names.<\/li>\n<li>Unlike some methods, will not lose your linked table or TableDef if there is an error.<\/li>\n<\/ul>\n<p>There are a few things the code will not do:<\/p>\n<ul type=\"disc\">\n<li>It will not relink Access database tables unless they have already been linked.<\/li>\n<li>It will not refresh the links of tables that have been renamed or moved to other back-ends.<\/li>\n<li>It will not relink tables that are in back-ends that have been renamed.<\/li>\n<li>It will not relink ODBC, Excel, Outlook, dBASE, Paradox or any other type of linked table or object.<\/li>\n<\/ul>\n<p><b>There are a couple of Requirements:<\/b><\/p>\n<p><b>1) The front-end and back-end tables must be in the same folder. <\/b><\/p>\n<p>Fulfilling this requirement allows the files to be moved to any folder, or a different computer, and the code will automatically relink the tables.<\/p>\n<p><b>2) The code that calls the RefreshTableLinks procedure must be added to the Form Open Event of the first form to be loaded or called by an AutoExec macro. <\/b><\/p>\n<p>To be more precise, the code must be run <strong>before a<i> <\/i>bound form loads data from the tables<\/strong>. So you could use other procedures in unbound forms, such as a Splash form, before calling the <b>RefreshTableLinks<\/b> procedure.<\/p>\n<p><b>The function that relinks the tables:<\/b><\/p>\n<p class=\"MsoNormal\"><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216; Procedure: RefreshTableLinks<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216; Purpose: Refresh table links to back-ends in the same folder as front end.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216; Note: Linked Tables can be in more than one back-end.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216; Return: Returns a zero-length string if all tables are relinked.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216; Return: Or returns a string listing tables not relinked and errors.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<br \/>\n<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Public Function<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> RefreshTableLinks() <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">As String<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">On Error GoTo<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> ErrHandle<\/span><\/p>\n<p><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Dim<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> db <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">As<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> DAO.Database<br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Dim<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> tdf <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">As<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> DAO.TableDef<br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Dim<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> strCon <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">As String<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Dim<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> strBackEnd <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">As String<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Dim<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> strMsg <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">As String<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Dim<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> intErrorCount <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">As Integer<\/span><\/span><\/span><\/p>\n<p><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Set<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> db = CurrentDb<\/span><\/p>\n<p><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;Loop through the TableDefs Collection.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">For Each<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> tdf <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">In<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> db.TableDefs<br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;Verify the table is a linked table.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">If<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> Left$(tdf.Connect, 10) = &#8220;;DATABASE=&#8221; <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Then<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;Get the existing Connection String.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\nstrCon = Nz(tdf.Connect, &#8220;&#8221;)<br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;Get the name of the back-end database using String Functions.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\nstrBackEnd = Right$(strCon, (Len(strCon) &#8211; (InStrRev(strCon, &#8220;&#8221;) &#8211; 1)))<br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;Verify we have a value for the back-end<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">If<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> Len(strBackEnd &amp; &#8220;&#8221;) &gt; 0 <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Then<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;Set a reference to the TableDef Object.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Set<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> tdf = db.TableDefs(tdf.Name)<br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;Build the new Connection Property Value.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\ntdf.Connect = &#8220;;DATABASE=&#8221; &amp; CurrentProject.Path &amp; strBackEnd<br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;Refresh the table link.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\ntdf.RefreshLink<br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Else<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;There was a problem getting the name of the back-end.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"comment1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #007700;\">&#8216;Add the information to the message to notify the user.<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\nintErrorCount = intErrorCount + 1<br \/>\nstrMsg = strMsg &amp; &#8220;Error getting back-end database name.&#8221; &amp; vbNewLine<br \/>\nstrMsg = strMsg &amp; &#8220;Table Name: &#8221; &amp; tdf.Name &amp; vbNewLine<br \/>\nstrMsg = strMsg &amp; &#8220;Connect = &#8221; &amp; strCon &amp; vbNewLine<br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">End If<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">End If<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Next<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> tdf<\/span><\/p>\n<p>ExitHere:<br \/>\n<span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">On Error Resume Next<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">If<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> intErrorCount &gt; 0 <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Then<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\nstrMsg = &#8220;There were errors refreshing the table links: &#8221; _<br \/>\n&amp; vbNewLine &amp; strMsg &amp; &#8220;In Procedure RefreshTableLinks&#8221;<br \/>\nRefreshTableLinks = strMsg<br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">End If<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Set<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> tdf = <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Nothing<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Set<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"> db = <\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Nothing<\/span><\/span><\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-ansi-language: EN;\"><br \/>\n<\/span><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Exit Function<\/span><\/span><\/span><\/p>\n<p>ErrHandle:<br \/>\nintErrorCount = intErrorCount + 1<br \/>\nstrMsg = strMsg &amp; &#8220;Error &#8221; &amp; Err.Number &amp; &#8221; &#8221; &amp; Err.Description<br \/>\nstrMsg = strMsg &amp; vbNewLine &amp; &#8220;Table Name: &#8221; &amp; tdf.Name &amp; vbNewLine<br \/>\nstrMsg = strMsg &amp; &#8220;Connect = &#8221; &amp; strCon &amp; vbNewLine<br \/>\n<span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">Resume ExitHere<\/span><\/span><\/span><\/p>\n<p><span class=\"keyword1\"><span lang=\"EN\" style=\"font-family: 'Courier New'; font-size: 10pt; mso-ansi-language: EN;\"><span style=\"color: #0000aa;\">End Function<\/span><\/span><\/span><\/p>\n<p>The above procedure only returns a message string if an error has occurred. This allows you to quietly record the successful relinking of tables in the Immediate Window instead of using an annoying MsgBox that pops up every time you open the database. However, you can use the MsgBox if need to notify the user when one or more of the tables fails to be relinked or there is an error.<\/p>\n<p><b>The code below shows one way to call the procedure and use the MsgBox to display errors. <\/b><\/p>\n<p class=\"MsoNormal\"><span lang=\"EN\" style=\"font-family: 'Courier New'; background: white; color: #0000aa; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\">Dim<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\"> strMsg <\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; background: white; color: #0000aa; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\">As String<\/span><\/p>\n<p><span lang=\"EN\" style=\"font-family: 'Courier New'; background: white; color: #007700; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\">&#8216;Run the Procedure, getting any error messages.<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\"><br \/>\nstrMsg = RefreshTableLinks()<\/span><\/p>\n<p><span lang=\"EN\" style=\"font-family: 'Courier New'; background: white; color: #007700; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\">&#8216;strMsg will be a zero-length string if there is no error message.<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\"><br \/>\n<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; background: white; color: #0000aa; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\">If<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\"> Len(strMsg &amp; &#8220;&#8221;) = 0 <\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; background: white; color: #0000aa; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\">Then<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\"><br \/>\n<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; background: white; color: #0000aa; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\">Debug.Print<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\"> &#8220;All Tables were successfully relinked.&#8221;<br \/>\n<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; background: white; color: #0000aa; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\">Else<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\"><br \/>\n<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; background: white; color: #007700; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\">&#8216;Notify the user of the errors.<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; color: black; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\"><br \/>\nMsgBox strMsg, vbCritical<br \/>\n<\/span><span lang=\"EN\" style=\"font-family: 'Courier New'; background: white; color: #0000aa; font-size: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN;\">End If<\/span><\/p>\n<p>It is a good idea to let the procedure run each time the database is opened. You can put the RefreshTableLinks Function in a Standard Module, add the code to call the procedure, and you are all done. You can forget about it &#8211; at least until there is a failure to relink a table. Barring corruption of a database, this should be a rare case; that is unless someone decides to move one of the files to a different folder or rename the back-end database.<\/p>\n<p>This code will only connect to Access Database tables that have already been linked in the front-end database. You can learn more by reading about the DAO TableDef Connect Property for <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ff193791.aspx\">Access 2010<\/a>. You can also learn more by reading about the DAO TableDef RefreshLink Method for <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ff198349.aspx\">Access 2010.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Automating the relinking of tables just makes good sense. This is especially true if you are distributing your database to others. It can save you a lot of headaches, trouble, travel, and time. You do not have to be physically present, nor do you need to remotely access another computer. Additionally, you do not have to enter the names of your back end database(s) or your linked tables.<br \/>\nIn this post, guest blogger Patrick Wood shows you how you can call a single procedure using just a little code to automatically relink your back-end tables, even when the database files have been moved to a different folder. The procedure will also relink the tables in multiple back-ends. And best of all, you don&#8217;t have to know much about writing code to make this work. <\/p>\n","protected":false},"author":18,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4037,4036],"audience":[4081],"tags":[4191],"coauthors":[4889],"class_list":["post-860","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-access","product-microsoft-365","audience-enterprise","tag-mac"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Automatically relink Microsoft Access tables | Microsoft 365 Blog<\/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:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automatically relink Microsoft Access tables | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"Automating the relinking of tables just makes good sense. This is especially true if you are distributing your database to others. It can save you a lot of headaches, trouble, travel, and time. You do not have to be physically present, nor do you need to remotely access another computer. Additionally, you do not have to enter the names of your back end database(s) or your linked tables. In this post, guest blogger Patrick Wood shows you how you can call a single procedure using just a little code to automatically relink your back-end tables, even when the database files have been moved to a different folder. The procedure will also relink the tables in multiple back-ends. And best of all, you don&#039;t have to know much about writing code to make this work.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-03T08:23:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-26T13:13:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/53\/0550.SUMMARY_LinkedTables_300x166.jpg\" \/>\n<meta name=\"author\" content=\"Courtney Owen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Courtney Owen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/courtney-owen\/\",\"@type\":\"Person\",\"@name\":\"Courtney Owen\"}],\"headline\":\"Automatically relink Microsoft Access tables\",\"datePublished\":\"2012-08-03T08:23:00+00:00\",\"dateModified\":\"2022-07-26T13:13:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/\"},\"wordCount\":1100,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/53\/0550.SUMMARY_LinkedTables_300x166.jpg\",\"keywords\":[\"Mac\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/\",\"name\":\"Automatically relink Microsoft Access tables | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/53\/0550.SUMMARY_LinkedTables_300x166.jpg\",\"datePublished\":\"2012-08-03T08:23:00+00:00\",\"dateModified\":\"2022-07-26T13:13:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/53\/0550.SUMMARY_LinkedTables_300x166.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/53\/0550.SUMMARY_LinkedTables_300x166.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Automatically relink Microsoft Access tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Automatically relink Microsoft Access tables | Microsoft 365 Blog","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:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/","og_locale":"en_US","og_type":"article","og_title":"Automatically relink Microsoft Access tables | Microsoft 365 Blog","og_description":"Automating the relinking of tables just makes good sense. This is especially true if you are distributing your database to others. It can save you a lot of headaches, trouble, travel, and time. You do not have to be physically present, nor do you need to remotely access another computer. Additionally, you do not have to enter the names of your back end database(s) or your linked tables. In this post, guest blogger Patrick Wood shows you how you can call a single procedure using just a little code to automatically relink your back-end tables, even when the database files have been moved to a different folder. The procedure will also relink the tables in multiple back-ends. And best of all, you don't have to know much about writing code to make this work.","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2012-08-03T08:23:00+00:00","article_modified_time":"2022-07-26T13:13:04+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/53\/0550.SUMMARY_LinkedTables_300x166.jpg"}],"author":"Courtney Owen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Courtney Owen","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/courtney-owen\/","@type":"Person","@name":"Courtney Owen"}],"headline":"Automatically relink Microsoft Access tables","datePublished":"2012-08-03T08:23:00+00:00","dateModified":"2022-07-26T13:13:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/"},"wordCount":1100,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/53\/0550.SUMMARY_LinkedTables_300x166.jpg","keywords":["Mac"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/","name":"Automatically relink Microsoft Access tables | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/53\/0550.SUMMARY_LinkedTables_300x166.jpg","datePublished":"2012-08-03T08:23:00+00:00","dateModified":"2022-07-26T13:13:04+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/53\/0550.SUMMARY_LinkedTables_300x166.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/53\/0550.SUMMARY_LinkedTables_300x166.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/08\/03\/automatically-relink-microsoft-access-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Automatically relink Microsoft Access tables"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/860"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=860"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/860\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=860"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=860"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=860"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=860"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}