Revealing the path of a linked table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a student Grade Card application that requires a link to a single
table in a student Fees application. I've added a button to a configuration
form and using a dialog box, select the database I want to connect to. I
want to display the path to the linked table in a text box next to the
button. How do I obtain the current path to the database that contains the
linked table?

Thanks!
 
Leighton.d said:
I have a student Grade Card application that requires a link to a single
table in a student Fees application. I've added a button to a configuration
form and using a dialog box, select the database I want to connect to. I
want to display the path to the linked table in a text box next to the
button. How do I obtain the current path to the database that contains the
linked table?
Click to expand...


It's in the Connect property of the table's TableDef object:

db.TableDefs!linkedtable.Connect


If the other database is an MDB file, then you can extract
the path this way:

Me.txtPath = Mid(CurrentDb,TableDefs!linkedtable.Connect,11)
 
Back
Top