Originally posted by VB4fun
no luck.

even if I start the program (in IDE) and run the report (#2) first and then unload all forms...it still shows the database open.

I am lost, here. I went to CR to change the database location to a different database (for grins)...and now when I try to run the routine...it is opening both of the databases..the old one and the new one....

since I am doing this in the code (the DSN you provided) why would it matter which one was set at design time...and why would it still be trying to access it..??
There are some issues with CR9 when you re-direct reports to another DB. You may neet to update your CR with the "HOTFIXES".

This might help you: GO HERE!!