PC Review


Reply
Thread Tools Rate Thread

How can I tell if an Access ADP is open

 
 
SimeonD
Guest
Posts: n/a
 
      17th Feb 2009
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


 
Reply With Quote
 
 
 
 
Tom van Stiphout
Guest
Posts: n/a
 
      18th Feb 2009
On Tue, 17 Feb 2009 12:13:02 -0000, "SimeonD" <(E-Mail Removed)>
wrote:

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

-Tom.
Microsoft Access MVP


>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
>

 
Reply With Quote
 
 
 
 
SimeonD
Guest
Posts: n/a
 
      18th Feb 2009
But surely regular i/o can't open an adp?
Anyway, will try it and see how I get on.
Thanks

"Tom van Stiphout" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Tue, 17 Feb 2009 12:13:02 -0000, "SimeonD" <(E-Mail Removed)>
> wrote:
>
> Using regular file i/o functions you could try to open the file
> exclusively.
>
> -Tom.
> Microsoft Access MVP
>
>
>>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
>>



 
Reply With Quote
 
Tom van Stiphout
Guest
Posts: n/a
 
      19th Feb 2009
On Wed, 18 Feb 2009 16:07:06 -0000, "SimeonD" <(E-Mail Removed)>
wrote:

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


>But surely regular i/o can't open an adp?
>Anyway, will try it and see how I get on.
>Thanks
>
>"Tom van Stiphout" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> On Tue, 17 Feb 2009 12:13:02 -0000, "SimeonD" <(E-Mail Removed)>
>> wrote:
>>
>> Using regular file i/o functions you could try to open the file
>> exclusively.
>>
>> -Tom.
>> Microsoft Access MVP
>>
>>
>>>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
>>>

>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Project Automatically Creates Files: adp1.adp, adp2.adp... Willie Microsoft Access 4 31st Oct 2009 05:12 PM
How can I tell if an Access ADP is open SimeonD Microsoft VB .NET 0 17th Feb 2009 01:13 PM
I've linked a ADP to SQL Database now I can't edit the ADP Table =?Utf-8?B?SGlkZXM=?= Microsoft Access 3 17th May 2006 10:01 PM
VB6 - Access ADP Database Custom Property / Or Read Line of Code In ADP Code Module WhatTha Microsoft Access VBA Modules 0 24th Jan 2006 04:26 PM
How to control ADP Connection when start ADP =?Utf-8?B?TmlraQ==?= Microsoft Access 0 11th Nov 2004 10:12 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:55 AM.