Post reply

Access 2002 Project Timeout to SQL Server

  • January 7, 2005 at 3:09 pm

    #66859

    I just got notified in a conference call meeting this morning that users at two remove sites are experiencing timeouts using my application.  I'm an outside consultant.  The client company uses Citrix over a VPN for these remote users.  The Access Project is a run-time version and is coded entirely with stored procedures and unbound forms.  It sits on a central network drive that is "shared" by all users via Citrix.  In-house users are not having any performance issues.  The database tables are small - all row counts less than 2000 rows.  Any ideas of where to look first?

     

  • January 7, 2005 at 4:09 pm

    #536545

    If the in-house users are not having any problems, I would first verify if the "timeouts" the remote users are getting are truly Access timeouts. Try to replicate the error over your own VPN connection.

    If they are using the app via Citrix over a VPN, then I would ask how 'close; is your app to the Citrix box that generates the pages to the users on the other end. That is to say that I suspect your timeout is not Access but, rather, lag time between the endpoints of the network conversation. In fact, you may even be generating a true Access timeout, but it is probably an aritifact of the network slowness.

    You can increase the timeout allowance between Access and SQL Server, but the rest of the equation has nothing to do with your application. Under 'File', choose 'Connection', then 'Advanced'.

    Good luck!

    Phil


    ciao ciao

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply