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

M

Mat N

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Active Content in this file is blocked issue 1
Error "The Object Doesn't contain the automation object Me" 0
How do I clear a form? 0
Database badly damaged 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
database opened exclusively by another user 1
Type Mismatch Error on IF conditional 3
ADO from .xls to .xlsm file - "Unrecognized database format" error 4

Top