[AccessD] ADPs and Exclusive Access Warnings

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