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

Pack10 · May 9, 2012

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 · May 9, 2012

You can try something like:

Code:

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

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

Code:

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

Duane
Hook'D on Access
MS Access MVP

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

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

Pack10

Programmer

dhookom

Programmer

Similar threads

Part and Inventory Search

Sponsor