Progamatically link tables

[Simon Morley]

Is there a way of linking a table relatively? I want to distribute a FE/BE
DB, but I don't know exactly where the folder is going to be put. What I
want to do is link the tables in such a way that I can use
CurrentProject.Path & "\Data\BackEnd.mdb" and then the table name so that
regardless of whether the users put the DB folder C:\Folder A\ or F:\Folder
B\ the links still work.

Many thanks in advance,

SCM

 

[Duane Hookom]

There is code at http://www.mvps.org/access/tables/tbl0009.htm. You could
modify the code in the function
Function fGetMDBName(strIn As String) As String
to return the relative path. Apparently you understand how to get the
current path.