table location? (1 Viewer)

[dgoulston]

table location? (solved!)

im sure this is a simple task but i cant figure it out

all i want to do is find the database location eg.

c:\myfolder\mydatabase.mdb

where a linked table is being accessed from...

and i need to do it in code and put the answer into a varible...


i can get the table origional name using
CurrentDb.TableDefs("mytable").SourceTableName

but need the full address not just the table name...


thanks
DAL

 

[dgoulston]

ok solved it

    Dim linkaddy As String, linktblname as string
    linkaddy = CurrentDb.TableDefs("mytable").Properties(4)
    linkaddy = Right$(linkaddy, (Len(linkaddy) - InStr(1, linkaddy, "=")))
    linktblname = CurrentDb.TableDefs("DNRACS").SourceTableName

DAL