[AccessD] ADPs and Exclusive Access Warnings

David Emerson davide at dalyn.co.nz
Tue Sep 21 16:17:07 CDT 2004


Correction - It is an ade

David

At 22/09/2004, you wrote:
>If it is any consolation, I have an 2002 ADP/SQL2000 configuration running 
>on Terminal server with up to 10 concurrent users and it works with no hitches.
>
>Regards
>
>David Emerson
>Dalyn Software Ltd
>25 Cunliffe St, Churton Park
>Wellington, New Zealand
>Ph/Fax (04) 478-7456
>Mobile 027-280-9348
>
>At 21/09/2004, you wrote:
>>I can't speak for Debbie but I have similar problems with .mdbs and .mdes
>>and I have to use a shared FE because we are a Terminal Services site. Users
>>do not get to change connection settings or design of objects and yet the
>>applications still frequently lock.
>>
>>I was hoping that .adps would NOT present the same problems, as we are
>>currently developing one for 200+ users (30 users at a time can be in one FE
>>on a terminal server).
>>
>>:(
>>
>>-----Original Message-----
>>From: Francisco Tapia [mailto:fhtapia at gmail.com]
>>Sent: 20 September 2004 22:42
>>To: Access Developers discussion and problem solving
>>Subject: Re: [AccessD] ADPs and Exclusive Access Warnings
>>
>>
>>If you change certain settings including the "connection Settings" then the
>>ADP want's exclusive access... I dunno why you would not want to distribute
>>as a normal FE one each pc... but this may be one of those Access error
>>messages.
>>
>>
>>On Mon, 20 Sep 2004 15:13:21 -0500, Elam, Debbie <delam at jenkens.com> wrote:
>> > Both adps are shared with several people.  I normally try to put front
>> > ends on the computer, rather than share to the network, but for a
>> > variety of reasons that is impractical in this case.
>> >
>> > Debbie
>> >
>> >
>> >
>> > -----Original Message-----
>> > From: Francisco Tapia [mailto:fhtapia at gmail.com]
>> > Sent: Monday, September 20, 2004 2:48 PM
>> > To: Access Developers discussion and problem solving
>> > Subject: Re: [AccessD] ADPs and Exclusive Access Warnings
>> >
>> > are you sharing the ADP w/ anyone?
>> >
>> > On Mon, 20 Sep 2004 14:30:08 -0500, Elam, Debbie <delam at jenkens.com>
>> > wrote:
>> > > I have 2 different .adps created in Access 2002.  Both of these are
>> > > giving
>> > a
>> > > message "You do not have exclusive access at this time...."  In both
>> > > instances, the user should not be saving any changes to the database
>> > anyhow.
>> > > I do not understand why these are popping up.  Personally I would
>> > > just prefer to suppress the message, but set warnings to false does
>> > > not do the trick.  Any ideas on either preventing the message, or
>> > > simply suppressing
>> > it
>> > > from displaying?
>> > >
>> > > Debbie
>>Website: http://www.databaseadvisors.com
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list