Hi,
Are you trying to query the database or do something else?

If the first case:
You can pull up data directly from Excel using the External Data featu
menu Data Get (or Import) External Data New Database Query. There choose
MS Access and follow the dialogs.
In vba, it is similar to buikding a QueryTable object. (do the step above
with the macro recorder On, then check at the automated code).

I hope this helps,
Regards,
Sébastien

"Mister T" wrote:

In an Excel routine, I access an Access database with a GetObject. But before
I do that, is there a way to find out if an instance of that particular DB
has already been launched? Thank you.

Hi,

My problem is not about manipulating the Access object from my Excel VBA
code. Rather, what I want is not to do these manipulations at all in the
first place in case the Access DB is already open. So what I want to do is
detect whether or not the DB has already been instanced.

"sebastienm" wrote:

Hi,
Are you trying to query the database or do something else?

If the first case:
You can pull up data directly from Excel using the External Data featu
menu Data Get (or Import) External Data New Database Query. There choose
MS Access and follow the dialogs.
In vba, it is similar to buikding a QueryTable object. (do the step above
with the macro recorder On, then check at the automated code).

I hope this helps,
Regards,
Sébastien

"Mister T" wrote:

In an Excel routine, I access an Access database with a GetObject. But before
I do that, is there a way to find out if an instance of that particular DB
has already been launched? Thank you.

Is it a db on a network drive or on your computer only? for shared or
exclusive access?

I don't know much about it, but i remember being in the case, years ago, of
an MS Access db sitting on a network drive in shared mode, and everytime
someone would use it, the db was automatically keeping track of the user by
adding his network name into a 'lock' (? can't remember exactly the name)
file saved in the same directory.
I was using that file to determine connected user and ask them to un-connect
so that we could maintain/modify the db.

Sorry i can't help more,
Sébastien

"Mister T" wrote:

Hi,

My problem is not about manipulating the Access object from my Excel VBA
code. Rather, what I want is not to do these manipulations at all in the
first place in case the Access DB is already open. So what I want to do is
detect whether or not the DB has already been instanced.

"sebastienm" wrote:

Hi,
Are you trying to query the database or do something else?

If the first case:
You can pull up data directly from Excel using the External Data featu
menu Data Get (or Import) External Data New Database Query. There choose
MS Access and follow the dialogs.
In vba, it is similar to buikding a QueryTable object. (do the step above
with the macro recorder On, then check at the automated code).

I hope this helps,
Regards,
Sébastien

"Mister T" wrote:

In an Excel routine, I access an Access database with a GetObject. But before
I do that, is there a way to find out if an instance of that particular DB
has already been launched? Thank you.

http://support.microsoft.com?kbid=138621
XL: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=291295
XL2002: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=213383
XL2000: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=184982
WD97: VBA Function to Check If File or Document Is Open

--
Regards,
Tom Ogilvy


"Mister T" wrote in message
...
Hi,

My problem is not about manipulating the Access object from my Excel VBA
code. Rather, what I want is not to do these manipulations at all in the
first place in case the Access DB is already open. So what I want to do is
detect whether or not the DB has already been instanced.

"sebastienm" wrote:

Hi,
Are you trying to query the database or do something else?

If the first case:
You can pull up data directly from Excel using the External Data
featu
menu Data Get (or Import) External Data New Database Query. There
choose
MS Access and follow the dialogs.
In vba, it is similar to buikding a QueryTable object. (do the step
above
with the macro recorder On, then check at the automated code).

I hope this helps,
Regards,
Sébastien

"Mister T" wrote:

In an Excel routine, I access an Access database with a GetObject. But
before
I do that, is there a way to find out if an instance of that
particular DB
has already been launched? Thank you.