Hey all,

I'm trying to compact a database in VB6. It won't let me do that until the .mdb file is closed. I can get the database closed with code in most cases, but not after I view a report generated by the Data Report tool. When the report is generated, the database will not close until the application is terminated. How in the world can I do this?

The name of my command in the Data Environment is Catalog, so I've tried:

Catalog.Connections.Item(1).Close

and all variations of that I can think of...

Please help!!!