[AccessD] Open report from remote db

Lonnie,

There are a couple of options - automation and referencing.  

Automation means the same thing that it does in Excel or Word, creating an
instance of the remote database and manipulating it to cause it to open the
report.  That is rather ugly because it is difficult to keep the manipulated
database from displaying itself in the process of manipulating it, i.e. it
wants to "open".  If the remote database has an autoexec or an autoform then
that will try to execute / open.  I am no expert in automation of Access
databases so there may in fact be methods to get around these issues. 

Referencing means creating a reference to the database so that you can run
code inside of the database.  Having done that, you can then create public
functions that take a report name as a parameter and then opens that report.
Since the data for the report is inside of the database (or linked to it
anyway) this works nicely.  Unfortunately references can get messy depending
on the circumstance.

As you can see, there are ways to do this and which you choose will depend
on your circumstances.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson
Sent: Thursday, April 12, 2007 11:14 PM
To: AccessD solving'
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




 



Sucker-punch spam with award-winning protection.
Try the free Yahoo! Mail Beta.


       
____________________________________________________________________________
________
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com