[AccessD] Open report from remote db

Lonnie,

    Two alternatives are available as follows, for viewing / printing reports & forms belonging to external db:

    (a) Library reference to external db:
    (i) In local db, set up library reference named "External" to the external db and then call subroutines & functions belonging to external db by using the qualifier "External." 
    (ii) In the code modules of external db, care is to be taken to use CodeDb & CodeProject in lieu of CurrentDb & CurrentProject respectively, wherever occurring.
    (iii) Automatic setting up of correct reference to external db can be ensured programmatically, through code in start-up form of local db.

    (b) Access automation:
    Activate the external db via automation and toggle respective visibilities of local & external db's appropriately, for user convenience.

    Two of my sample db's mentioned below, might be of interest to you:
    (a) ExternalDbAsLibraryRef
    (b) ExternalDbAutomation

    Both samples are available at Rogers Access Library (other developers library). Link - http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.
 
    You could adapt the underlying approach suitably, for your specific needs.
 
Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Lonnie Johnson 
  To: AccessD solving' 
  Sent: Friday, April 13, 2007 08:44
  Subject: [AccessD] Open report from remote db


  Can you open a report in one database from another database? 
   
  I know how to get the data from a query or table in another database with...
   
  "SELECT * FROM TABLE/QUERYMAME IN 'C:\MYDB.MDB'"
   
  Any help?
   
  May God bless you beyond your imagination!
  Lonnie Johnson
  ProDev, Professional Development of MS Access Databases
  Visit me at ==> http://www.prodev.us