How to determine what Databases are Open?

[tjcusick]

Any know of a tool or a procedure to tell at a specific point what databases are opened?

 

[lespaul]

I would guess that you would need to have a public variable (StringList maybe?) and each time you open a database add that database name to the list and when you close a database remove that name from the list. That way you will have a list of all open databases.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins