Hi
is it posible to check if another database is open?
i have several datasbase
the first is a dbase where the local data is maintained
on closing the database the table is exported to a holding table which
is linked to another database. ( this is done beacuse some users may
not have write access to the source file or it may be open)
the second database is linked to all the holding tables. Allowing the
all the tables to be linked and searched.
Problem is if someone has both open the export macro Action Fails.
What i want to do is check if the second dattabase is open
if not run a macro that exports the table
if it is open do not run the macro
let call the tables
source.mdb
and search.mdb
source.mdb exports to the holding table
can this be done in code
thanks
kevin