Can I do automation on Access if the database is open?
 

I'm trying to write some code which will check to see what databases
are currently open. I've made some progress on this front with a
little help from the following links';
http://support.microsoft.com/kb/q183009/
http://www.oaltd.co.uk/Excel/Default.htm (look at the EnumDlg.xls)

Once I've found which databases are open I want to list out the
(queries and tables) they contain (or at least which ever one I select
assuming there is more than one database open).

I've been assuming I can use the GetObject() to create link to the
open database but I'm getting an error:

Run time error '-2147467259 (80004005)':
Microsoft office Access can't open the database because it is missing
or opened exclusively by another user.

I thought CreateObject would open the file not GetObject?

Is it not possible to list out the queries and tables of database that
is currently open?