You should be able to access a BE in a different directory by replacing CurrentProject.Path in the line below with the path to your other directory.
<code>
tdf.Connect = ";DATABASE=" & CurrentProject.Path & "" & strBackEnd
</code>
The string would look something like this: "C:\path\to\BE"
OR...