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
Can't open my Access files after conversion from Access 97 to Access 2003 M Shafaat Microsoft Access 5 10th Apr 2010 09:04 PM
Access 2007 Open forms with FilterOn and form fails to open merwcat Microsoft Access Form Coding 5 7th Aug 2008 01:18 PM
how can i open the open file dialog in access 2003 programming cyndi Microsoft Access Form Coding 1 3rd Jan 2008 01:33 AM
Access 2003 database will not open unless you open access first (m Rob Saunders Microsoft Access 4 27th Nov 2007 09:24 PM
On Open Event to open Datasheet when Form opens in Access =?Utf-8?B?bGlzZWR1bQ==?= Microsoft Access Forms 6 21st Jun 2006 02:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:09 AM.