Hi All,

My tables are linked to a Backend called DMS.mdb in:
S:\General\Databases\DMS\DMS.mdb

Could someone give me a function which would return the full path to
the backend, including of not including the db name:

msgbox "Location of Backend: " & FunctionName

Thanks,
Barry

Barry Edmund Wright wrote:

This returns the full path of a linked table else null.

Public Function GetBEName(strTable) As Variant
GetBEName = DLookup("Database", "MSysObjects", "Name='" & strTable &
"' And Type=6")
End Function

msgbox GetBEName("YourTableName")

Thanks Salad, exactly what I wanted.
Cheers,
Barry

On Aug 13, 10:38*am, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:

Salad <salad (AT) oilandvinegar (DOT) com> wrote in
news:uLmdndLzfoNgxfjRnZ2dnUVZ_t2dnZ2d (AT) earthlink (DOT) com:

Heavens, I always use:

Mid(CurrentDB.TableDefs(strTable).Connect, 11)

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

David W. Fenton wrote:

Salad <salad (AT) oilandvinegar (DOT) com> wrote in
news:dsidnd3SS5BjjvvRnZ2dnUVZ_s2dnZ2d (AT) earthlink (DOT) com:

What I meant was that I don't even have a function for this -- I
just type in the Mid() statement as above.

Actually, I do have a function for it, but don't use it any more.

I do have something of a love affair with Mid() -- I use it all over
the place for all sorts of things, particularly capitalizing on Null
concatenation with the + operator.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

On Aug 14, 2:23*pm, "David W. Fenton" <NoEm... (AT) SeeSignature (DOT) invalid>
wrote:
There's always all the shlwapi DLL functions. I tend to use those
*alot* for anything to do with path and file name manipulation.

Wow.. I got tired of using jet backends a decade ago.. and decided
that moving to SQL Server gives better performance, scalability,
stability _AND_ it's easier to program against.





On Aug 13, 7:15*am, Barry Edmund Wright
<barry.edmund.wri... (AT) witstoronto (DOT) ca> wrote: