[AccessD] Running a report in an external database

On 19 Mar 2005 at 11:23, Rocky Smolin - Beach Access S wrote:

>                  
> 'Open Reports.mdb hidden, print Report and close that mdb.
> 
> Dim acc As Access.Application
> Set acc = CreateObject("access.application")
> acc.OpenCurrentDatabase ("c:\Acessdat\Reports.mdb")
> acc.DoCmd.OpenReport "rptEvictionCase-MemoToSet", acViewNormal
> acc.CloseCurrentDatabase
> Set acc = Nothing

You have told the hidden Access Application to close its current database, 
but not to close itself, so you still have a hidden instance of Access with 
no open database.

Try acc.Quit instead of  acc.CloseCurrentDatabase.



-- 
Stuart