How can I tell if an Access ADP is open

[SimeonD]

Hi
From VB.Net, I need to check if an Access ADP is already open. If it was an
mdb, I would check for an ldb file. But that doesn't occur for adp, so don't
know what to check for.
Thanks
Simeon

 

[Tom van Stiphout]

On Tue, 17 Feb 2009 12:13:02 -0000, "SimeonD" <[email protected]>
wrote:

Using regular file i/o functions you could try to open the file
exclusively.

-Tom.
Microsoft Access MVP

 

[SimeonD]

But surely regular i/o can't open an adp?
Anyway, will try it and see how I get on.
Thanks

 

[Tom van Stiphout]

You asked for a check if an ADP is already open. You did not ask to
open it and do anything meaningful with it.
If you can open an ADP file exclusively, then obviously it is not open
by another application (presumably Access).

-Tom.
Microsoft Access MVP