Re: Access Project (adp) with Sql Server 2000 - First Connection Latency

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Vadim,

has taken me a while to find the time to test the whole mess again.
I created a new adp and connected it to the sql-database.

I close the adp, wait for 1 minute, open it again and it takes 15 sec.
I close it again, don´t wait, open it again and it opens immediately.

I installed Client Connectivity Tools for Sql Server and made shure the
connection
takes place over tcp/ip. I updated the tcp/ip networklibrary.
Nothing changed.

Afterwards I tried the same thing on another machine in the customers
network, where I had access installed. It was Terminal Server 2003 (?)
and Access XP. Created new ADP and the Connection opens always
immediately - even if I wait more than 1 minute.

My conclusions are either
- Problem with Access 2000 or
- Problem with Windows 2000.

Customer will try to install Access XP/ 2003 on a machine with the
latency-problem...

Thanks for your help - I will write down the solution as soon as found
:-)

Gerhard

.

Relevant Pages

  • Re: ADP vs. MDB?
    ... One major problem we had was that in an adp all calls to the database seem ... to run in the same connection context (i.e. adp opens one connection to the ... revert to an .mdb, open and close my own connections as required, implement ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access Project (adp) with Sql Server 2000 - First Connection Latency
    ... G> I created a new adp and connected it to the sql-database. ... G> I close it again, don´t wait, open it again and it opens immediately. ... Created new ADP and the Connection opens always ... With best regards, Vadim Rapp. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Sql Server 2008 Developer Edition
    ... I've given up after a 4th install on a clean machine. ... what type of query window I try to open I only get an MSAS connection popup. ... Assuming Object Explorer opens up correctly, ...
    (microsoft.public.sqlserver.setup)
  • Re: Changing Servers
    ... Open the adp with the shift key down, opens without ... timeout and then you can set the connection. ... >> I create an ADP connected to Server A. The app works ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... So it is a kind of asynchronous commit which happens every 10 ... I am not sure of this claim as we have many applications built on SQL CE ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)