How can I add a "Linked" database name to my report?

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

Guest

In my Master database, I have several tables linked to another database. I
want to run a report in the Master database that includes the name of the
database the Master database is linked to. Can this be done?
 
You can try set a text box control source to:
=Mid([Currentdb].[tabledefs]("A Linked Table Name").[Connect],11)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 replica to master 4
Filtering subreports on main report 0
Query two identical tables without combining 4
Reports that sift records from different tables 0
Printing a report for a single ID 1
Reports from two databaes 3
What are the steps to fix damaged MDF files in SQL Server? 0
Access how to open existing database from another database using Access - VBA 0

Back
Top