Lonnie Johnson
prodevmg at yahoo.com
Sun Apr 15 20:01:43 CDT 2007
Thanks for the tip. I have set a reference but do "see it" as you say. I may need a little more hand holding. Never had to do this before. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: Michael R Mattys <mmattys at rochester.rr.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Thursday, April 12, 2007 10:23:10 PM Subject: Re: [AccessD] Open report from remote db Hi Lonnie, Set a ref to that mdb and you should be able to 'see' it to call it. Michael R. Mattys MapPoint & Access Dev www.mattysconsulting.com ----- Original Message ----- From: Lonnie Johnson To: AccessD solving' Sent: Thursday, April 12, 2007 11:14 PM 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com