Does anybody know how to check to see if there are any open database connections, workspaces and recordsets in a project.

If there are any is it possible to create a collection loop through it and close them all.

Any suggestions would be appreciated.

Thanks