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?