How do you programmatically display the location of the back-end db

[Pack10]

I have a split database and I would like to display on the main form the location (folder) of the linked tables.
I have a test and prod folder for the back end and just in case I make a mistake, I want to see where the database is pointing.
How would i do that?

 

[dhookom]

You can try something like:

Dlookup("database","msysobjects","Name='Your Table Name Here'")

This assumes your table names are not repeated as other object types.
or

Mid(Currentdb.TableDefs("Your Table Name Here").Connect,11)

Duane
Hook'D on Access
MS Access MVP