Link two Microsoft Access tables via vba
<p>I'm trying to link two tables in different databases. What I've done is create a new table and then try to change the DESCRIPTION property to a path of a specific table in the other Database.</p>

<pre><code>Set dbs = CurrentDb
thepath = "DATABASE=P:\Cadworx P&amp;ID Implementation\3 Piping\P&amp;IDs Jesus Test\Testproject\myTest.mdb;TABLE=Service"

Set tdf = dbs.TableDefs("ThisTable")

On Error Resume Next

tdf.Properties("Description") = "DATABASE=P:\Cadworx P&amp;ID Implementation\3 Piping\P&amp;IDs Jesus Test\Testproject\myTest.mdb;TABLE=Service"

If Err.Number = 3270 Then
Set prp = tdf.CreateProperty("Description", _
    dbText, thepath)
tdf.Properties.Append prp
End If
</code></pre>

<p>This hasn't given me the desired results, as the link is never established. Can someone please tell me if this is the right way to do this or if there is a better way? Thanks for your help.</p>